How to resolve the error "Run-time error 2282" when using DoCmd.OutputTo acOutputReport in Access 2007 with an MDB type file?

zimmer9 used Ask the Experts™
I created an Access VBA application using an MDB type file in Access 2003.

Within this application, I issued the following command to export a report to Excel and it worked fine:

ExportedFile = CurrentProject.Path & "\Reports\SumDollar"  & ".XLS"
DoCmd.OutputTo acOutputReport, "rptSummaryReport", 8, ExportedFile

However, when I tried my Access application using Access 2007, the statement:

DoCmd.OutputTo acOutputReport, "rptSummaryReport", 8, ExportedFile
generates the following error message:

Run-time error 2282:

The format in which you are attempting to output the current object is not available.

Do you know if this statement will work successfully if I migrate to Access 2010?

Do you know how I can resolve this error?

The reason I used an Access report (instead of the DoCmd.Transferspreadsheet command) is because the exported records include subtotals and totals.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

DoCmd.OutputTo acOutputReport, "rptSummaryReport", acFormatXLS, ExportedFile

also, from vba window do a debug >compile

correct any errors raised,  then do a compact and repair

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial