Prompt for file location Export to Excel

[Proko]

I am currently using the following line of code to export the results of a
query to an Excel spreadsheet.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7,
"qry_dataoutput", "c:\temp\test.xls"

Is it possible for the user to be able to select where the xls file will be
written rather than the file always going to the same destination.

Thanks in advance.
Proko

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api/api0001.htm for how to invoke
the standard Windows FIle Save dialog.

 

[Ken Snell MVP]

See this article. It shows how to do this for importing; changing it for
exporting will be easy for you.

Browse to a single EXCEL File and Import Data from that EXCEL File via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ImpBrowseFile

 

[Proko]

Thankyou Gentlemen! Most appreciated.

See this article. It shows how to do this for importing; changing it for
exporting will be easy for you.

Browse to a single EXCEL File and Import Data from that EXCEL File via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ImpBrowseFile

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/