Export like a Save As

  • Thread starter Thread starter Marc
  • Start date Start date
M

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
 
Marc said:
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.
Click to expand...

You can adapt the code at:

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

to display the Windows File Save dialog.
 
Back
Top