Creating a "Save As" window

[djmc]

I have code which converts a query to XLS format.

DoCmd.OutputTo acOutputQuery, "QUERY_NAME", acFormatXLS, "C:\DIRNAME\FILENAME.xls"

I would like to know how I can create a "Save As" text field/button so that I can have the user choose which directory they want the file in and pass the variable it into that line of code instead of having the directory being static.

 

[adherennium]

If you omit the directory "C:\DIRNAME\FILENAME.xls"
from your code, when the code is run, a window is automatically opened to allow selection of a directory.