setting up a macro prompt

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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
 
Back
Top