File Select within Macro (1 Viewer)

RevJeff

Registered User.
Local time
Today, 10:09
Joined
Sep 18, 2002
Messages
125
I have a macro that uses ImportExportSpreadsheet option, but the file is hardcoded. Is there a way, within the macro, to open a select dialog box to allow me to select a file. I know I can be done with VBA just didn't know if there was a way within the Macro.

Thanks
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:09
Joined
Oct 29, 2018
Messages
21,357
Well, maybe you could use VBA to open the file dialog and then save the user's selection into a macro variable. Other than that, I am not sure how else you might do it. Let's hope others will have a better idea.
 

Users who are viewing this thread

Top Bottom