Capture OutputTo Destination and Filename?
I'm using the OutputTo method to deliver query results from Access to the user in an Excel worksheet. I leave the destination/filename parameter blank so the user can select the directory path and pick their own filename. The dialog box looks just like the Save As dialog box.
I would like to capture the directory path and filename from the dialog box so that I can open the sheet and do some formatting before the user gets to it. I have the code to do the formatting, but it depends on the path/filename, which I'd like to pass it.
Does anyone know how to capture that path/filename from the OutputTo dialog?