Prompt for a file name in a script macro

P

Phil Hibbs

I have a script-style macro that I have taken over from someone else.
It opens a fixed file name, and I want to make it prompt the user for
a file name instead. Is there an expression in a SetTempVar action
that I can call that pops up a file selection dialog, so I can use
that temp var later on in the TransferSpreadsheet action?

Phil.
 

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

Use a Temporary Variable in a Macro 4
Re: Macro to inport excel file to table in access 2007 2
A prompt for TransferSpreadsheet Action in the File Name 1
Remove prompt for replacing file 5
setting up a macro prompt 3
searchforrecord macro pulling wrong record 5
The expression you used has a function name Access can't find 2
macros with a macro 1

Top