I found a post in this forum on out outputting a report to Excel using access 2007, saying that it does not work.
This is what I am trying to do with access 2007 (hoping that the problem has now been fixed):
DoCmd.OutputTo acOutputReport, "total", acFormatXLS, "c:\personal\pdf_files\report.xls", True
The error says access cannot save the data to the output file.
If I go to the Report itself, and right click, I can save it as excel.
So perhaps it now does work in vb but I have got something wrong.
Thanks