+ Reply to Thread
Results 1 to 8 of 8

i wanted to import batchname called (tblprod_agr_006) how can do it using this code

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    i have module in that module i have used label called[BatchName] and Textbox and button[Import New Batch] and have listbox1
    if i Click the button[import New Batch] It should import
    i dont know what to do Please help me out i am Confused here


    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    Need more info
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    May be if you are calling the form controls from module then mention the userformname before the controls names.

    Userform1.batchID
    Userform1.msgLabel.Caption

  4. #4
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    its showing an error-method or data member not found

    Please Login or Register  to view this content.

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    If the code is in the Userform Code window then there is no need to use the Userform name

  6. #6
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    UserForm1.batchID ------>in this is line
    UserForm1.msgLabel.Caption


    both do nothing, what are they meant to do?

  7. #7
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    this is my code to import batches please let me know

    Please Login or Register  to view this content.

  8. #8
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: i wanted to import batchname called (tblprod_agr_006) how can do it using this code

    Why keep posting different code. Can you just post what you want, where the error is and what code you have, you've had code for closebutton click and now the improt button.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. i wanted import batchname but it is not taking batchname please help me out
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2014, 05:44 AM
  2. i want to update multiple batches(tblprod_agr_006,tblprod_agr_007) pls help me out
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2014, 07:38 AM
  3. Replies: 4
    Last Post: 05-12-2014, 03:25 AM
  4. Editable combo. Elaborate code example wanted.
    By keepITcool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2005, 08:05 AM
  5. Why does my code not get run/called?
    By mdpx2005 in forum Excel General
    Replies: 1
    Last Post: 02-07-2005, 07:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1