Access 2007 output to Excel not working

[appelq]

I have several MS Access databases created in prior versions of Access (i.e. 2003) that have reports that get exported to Excel.
A Macro runs various queries, and the final step is using the Output To macro command to create a new Excel Spreadsheet.
It works fine using Access 2003 but now some of my users have been upgraded to Office 2007 and the Access reports no longer work on their PC's. they get an error -1524.
Is there a work around? I can re-write the them in VBA, but there a so many to update, I'm hoping for something easier to implement.

 

[boblarson]

There is no export of reports to Excel in 2007. They removed that option. So, if you want to export a report to Excel you will need to use VBA with the Excel object model.

Bob Larson
Access MVP
Free Access Tutorials and Samples:

http://www.btabdevelopment.com