Report not exporting to Excel (just closes)
Posted on 2007-03-19
I'm running Access 2002 on Windows XP.
I have report that runs fine in Access but when I click "Analize it with Excell" the exporting dialog comes up for 2 seconds then disappears. The report is not created but I don't get an error message. Other reports open and export fine and I've tried rebooting my computer.
I tried exporting it with code:
DoCmd.OutputTo acOutputReport, "rptMyTestReport", acFormatXLS, "C:\test.xls"
When I run it, I get the following error: "Run-time error '2759': The method you tried to invoke on an object failed."
Any ideas what could be causing the report to not export? It was exporting earlier. There is some code that runs on the formatting of the details section, but I've tried removing the script, but no change.
Thanks a lot for any help!