+ Reply to Thread
Results 1 to 7 of 7

Prompting for parameter value using macro

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    85

    Prompting for parameter value using macro

    Hi,

    Last time i got macro from this forum how to import files automatically.
    I am importing the data from the specific folder.In code itself we are hardcoding that file names.But in that folder
    i have lot of files is there any option to pass any parameter value.That means each time it will asks for filename(Prompt).Once you give
    file name it will automatically load the data.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Prompting for parameter value using macro

    Try this:

    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    03-09-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: Prompting for parameter value using macro

    Hi Millz,

    Your code is just like browse to open file.But my requirement is macro will ask for filename.If i entered file name it will pick that file
    from that folder.

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Prompting for parameter value using macro

    So you just want a simple input box? Like this maybe:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-09-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: Prompting for parameter value using macro

    Hi Millz,

    Excellent it's working fine...

  6. #6
    Registered User
    Join Date
    03-09-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: Prompting for parameter value using macro

    Hi Millz,

    I have one issue.If i have lot of sheets in excel.If i want to load into particular sheet for example sheet6.how to do this

  7. #7
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Prompting for parameter value using macro

    Change here:

    Please Login or Register  to view this content.

+ 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. Message prompting that macro run is finished.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2013, 11:38 AM
  2. Prompting Macro
    By schaasyd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2012, 09:39 AM
  3. Macro for prompting date entry
    By Armored Wing in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-14-2012, 07:44 PM
  4. Need help prompting in Macro
    By DarkDevin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2011, 03:49 PM
  5. prompting user for macro parameter
    By peacelittleone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2005, 02:23 PM

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