File Save As Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the following to output a table, tblRollingRent", to Excel. I'd
like to present the user with a Save As dialog box rather than saving the
document to My Documents where it gets saved by default now. What's the
easiest way to do that?

DoCmd.OutputTo acOutputTable, "tblRollingRent", acFormatXLS,
"RollingRent.xls", True
 
Mic Greenbriar said:
I'm using the following to output a table, tblRollingRent", to Excel.
I'd like to present the user with a Save As dialog box rather than
saving the document to My Documents where it gets saved by default
now. What's the easiest way to do that?

DoCmd.OutputTo acOutputTable, "tblRollingRent", acFormatXLS,
"RollingRent.xls", True
Click to expand...

I'd call the Windows File Open/Save dialog directly, using the code
posted here:

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