J
John Hipskind
Is there anything like a Browse function available, where
a file can be selected from a Windows Open dialog? I
would like to create a macro that selects an Excel file
to import from such a dialog.
Using a macro based on the TransferSpreadsheet action
with the following FileName argument:
= InputBox("Enter the filename:")
works great (suggested by Ken Snell), but requires typing
the path and filename.
Thanks.
John
a file can be selected from a Windows Open dialog? I
would like to create a macro that selects an Excel file
to import from such a dialog.
Using a macro based on the TransferSpreadsheet action
with the following FileName argument:
= InputBox("Enter the filename:")
works great (suggested by Ken Snell), but requires typing
the path and filename.
Thanks.
John