Export to Excel: user defined location?

[faberk]

I searched here for an answer, but did not see anything posted.

I wish to transport the results of a query to ms excel to a location defined
by the user. I would like a dialogue box to be displayed, that asks the user
where they wish to store the file and the file name, similar to the standard
windows style. Im using the following code. How do i modify it to
accomodate this?

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"qryTransfer", "c:\transfer.xls"

 

[Rob Oldfield]

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

.... let's you open a default file, save box and returns the path chosen.