A prompt for TransferSpreadsheet Action in the File Name

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Use an expression for the File Name argument:

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