Export report to Excel, Error message "Compile Error: Argument not

M

mc

I took over an existing Access application. I am running Access 2003. There
is an existing query that the user runs a macro that creates a spreadsheet
The user wants totals at gl # in the spreadsheet. I created a new report
that uses the existing query and added the totals at the gl footer. I have
no problems running the report, it's called rpt_create_recon_final. I went
to dump this report to excel, when I run the command "docmd.OutputTo
acOutputReport,
"rpt_create_recon_final",acFormatXLS,"c:\temp\output.xls",true", I get the
error message of "Compile Error: Argument not optional". Not sure what I am
doing wrong.
 

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

Export Report with Graph to Excel error 2495 1
Some of the sum totals are exporting to Excel 0
Integrating information from Word to Excel (not mail merge) 1
Calling Error Handling in VBA 0
Calling Error Handling in VBA 0
Export to Exel using Access 2000 and 2007 1
Module Import error: Compile err 1
Optional argument as Variant not acting like number 4

Top