File Select within Macro

[RevJeff]

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]

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.

 

[namliam]

a way within the Macro.

Another reason to stop using Macro's ...

as far as I know, no not possible.