setting up a macro prompt

G

Guest

I am trying to set up a macro with the "transferspreadsheet" command. Under
the "Action Arguments" section at the bottom, the user is asked to provide
the file from which the data is to be imported. Instead of always pulling
the data from one file, I would like it to prompt the user for the file name
and location. How can I do that?
 
C

Chris Reveille

In the file name of the macro put
= InputBox("enter the path and filename:")

Chris
-----Original Message-----
I am trying to set up a macro with the
Click to expand...
"transferspreadsheet" command. Under
 
K

Keith

Is it not possible to bring up an 'Open File' explorer type selection box
where it is possible to browse for the relevane file or better still a
pre-determined folder which contains the files as you can in Excel VBA?

Thanks

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt for a file name in a script macro 0
Remove prompt for replacing file 5
macros with a macro 1
cannot expand named range 1
TransferSpreadsheet macro action is not available. 1
prompt for function arguments? 1
searchforrecord macro pulling wrong record 5
Error When Using TransferText in a Macro 1

Top