I am building a button to export reports to an excel spreadsheet. I know how to use the OutputTo with variables to save a file to a specific place.
Example:
DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, stDocPath, False
But they want the ability to specify the directory location, kind of like when you do a file save as and then select where you want the file to go.
Other than putting a prompt in for them to type in the path/file name, what other options would allow them to specify the location and name of the file?
Example:
DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, stDocPath, False
But they want the ability to specify the directory location, kind of like when you do a file save as and then select where you want the file to go.
Other than putting a prompt in for them to type in the path/file name, what other options would allow them to specify the location and name of the file?
