File Save As Box

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
 
D

Dirk Goldgar

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
 
M

Marshall Barton

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting table to Excel - getting error - help please. 2
Export Access Table and format it in Excel 2
Fixed length when exporting to Excel 3
export table and give it a name from the value in another unbound table 1
Object variable or With block variable not set 1
Yes/No data type exporting as True/False 1
OutputTo file name 3
User cancels Dialog Box in OutputTo method 2

Top