Hi
I read a number of posts on this forum and although other users have experienced the same issue, there were no clear answer yet. Perhaps with some new knowledge someone can assist.
I'm trying to export a report to Excel.
I'm using Access 2010, but the client only have Excel 2003.
I run:
DoCmd.OutputTo acOutputReport, "MyReportName", acFormatXLS, , True
When I run it on my PC is works (design time).
When I run it on the client PC (with Access 2010 - design time), it works.
When I run it on the client PC (with the Access runtime), it does not work.
I get the error: The format in which you are attempting to output the current object is not available.
From the other posts in this forum, the closest suitable answer is that it is not possible and you can only export queries. I do believe there's a solution to export a report.
I read a number of posts on this forum and although other users have experienced the same issue, there were no clear answer yet. Perhaps with some new knowledge someone can assist.
I'm trying to export a report to Excel.
I'm using Access 2010, but the client only have Excel 2003.
I run:
DoCmd.OutputTo acOutputReport, "MyReportName", acFormatXLS, , True
When I run it on my PC is works (design time).
When I run it on the client PC (with Access 2010 - design time), it works.
When I run it on the client PC (with the Access runtime), it does not work.
I get the error: The format in which you are attempting to output the current object is not available.
From the other posts in this forum, the closest suitable answer is that it is not possible and you can only export queries. I do believe there's a solution to export a report.
