Trying to export an Access Report to Excel using VBA
Posted on 2002-03-20
I can do it manually through the menus just fine.
but when I try
DoCmd.OutputTo acOutputReport, "GraphData", ".xls", "C:\My Documents\GraphData.xls"
I get the error:
RunTime Error 2282
"formats that enable you to output data as a MS Excel, Rich Text, or HTML file are missing from the Windows Registry."
I assume if that were true, I wouldn't be able to do it manually either.
I want to export the report and not the query, because of the formatting on the report.
thanks (yet again)