I am using the following code that copies a query into an Excel spreadsheet.
How do I tweak the code so that the standard Windows File Open/Save dialog box opens so the user can save in another file location?Code:DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "myQuery", "C:\Documents and Settings\jpkeller\jk.xls", True
Thanks for any help.