Hello,

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?

Thanks!



steve

Use Msgbox to write your own dialog box, process the input and then include the final path in the Output statement.

Cheers Ray

Thanks for replying, Ray. I actually got it to work (after lots of trial and error) through the Excel GetSaveAsFilename dialog box, which gives me the selection of the diretory path as well as filename.
Thanks again.

steve