File Save As Box

[Mic Greenbriar]

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

 

[Allen Browne]

You can call the Windows File SaveAs dialog using this code:
http://www.mvps.org/access/api/api0001.htm

 

[Dirk Goldgar]

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

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

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

 

[Marshall Barton]

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

For file browsing:
http://www.mvps.org/access/api/api0001.htm

and for folder browsing:
http://www.mvps.org/access/api/api0002.htm