how to give a user an option to choose where to save the outpur file

[sabavno]

Hi

I was wondering if anyone knows how implement the following:

I send the table to the excel spreadsheet file. The location of the excel file is hardcoded. However it is sort of limiting for the user in case she/he wants to save the file in their own directory. So I want to give that option to the users so they can choose the directory they want

Please let me know if there is a way to do that

Thanks

 

[josephwalter]

If you're using an Access Module to perform the export, could you use the InputBox command to get the file path the user wants to save the file to - and then use that file path in your export command? I can give you a code example, if this is how you would like to do it.

 

[meyergary]

Look up the OutputTo method in help. If you leave the fourth argument blank, it'll prompt the user for a filename (and path).