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

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.
zimmer9Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try

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


also, from vba window do a debug >compile

correct any errors raised,  then do a compact and repair

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.