Export like a Save As

[Marc]

I would like to use the "DoCmd.TransferSpreadsheet
acExport" for exporting a Query but emulating a Save As.
This is: when clinking on the export button, a form will
pop up allowing the user to navigate into his or her own
hard drive to identify the destination of the excel file
and then enter its name. Especially I am interested that
the PopUp form allows the user to navigate into his or her
hard drive without having to type manually the file path.

Thank you very much,

Marc

 

[Dirk Goldgar]

I would like to use the "DoCmd.TransferSpreadsheet
acExport" for exporting a Query but emulating a Save As.
This is: when clinking on the export button, a form will
pop up allowing the user to navigate into his or her own
hard drive to identify the destination of the excel file
and then enter its name. Especially I am interested that
the PopUp form allows the user to navigate into his or her
hard drive without having to type manually the file path.

You can adapt the code at:

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

to display the Windows File Save dialog.