TransferSpreadsheet

[Guest]

I'm trying to export data from a query to excel but I need the 'save as'
dialog box to prompt the user for a file name.


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "qryExcel",
"C:\Archive\FileName.xls", True

TIA,
Duncan

 

[Ken Snell [MVP]]

This page on The ACCESS Web has code for using the API to do this. You can
substitute the ahtCommonFileOpenSave function call in the argument list in
the TransferSpreadsheet action:

http://www.mvps.org/access/api/api0001.htm