A prompt for TransferSpreadsheet Action in the File Name

G

Guest

I have an interesting question. . . I'm trying to create a prompt in the
TransferSpeadsheet Action for the "File Name" in a Macro. Meaning when I run
the macro I want a prompt to ask me what the name of the file is that I wish
to import from excel. Is that possible?
 
K

Ken Snell \(MVP\)

Use an expression for the File Name argument:

=InputBox("Enter the full path and file name for the EXCEL file:")
 

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

TransferSpreadsheet in macro not avaiable 2
Prompt for a file name in a script macro 0
MIssing Transferspreadsheet Action 1
Question about "TransferSpreadsheet" action 4
Remove prompt for replacing file 5
TransferSpreadsheet Macro 1
TransferSpreadsheet 2
Re: Macro to inport excel file to table in access 2007 2

Top