Access Report export question: DoCmd.OutputTo can't export Excel 1997-2003 format?
Posted on 2010-01-10
This is a big problem for me and I hope it's resolvable:
I wanted to automate the saving process of Access reports by using DoCmd.OutputTo:
DoCmd.OutputTo acOutputReport, "rptTemplate", acFormatXLS, "sample.xls"
In the mean time, we could manually export the report after opening it by choosing either:
"Excel 5-7" or "Excel 1997-2003".
Unfortunately, I found DoCmd.OutputTo could only export "Excel 5-7" format.
Seems I could not use DoCmd.TransferSpreadsheet for Access Reports and I do not want to change registry settings. Is there any workaround if I use DoCmd.OutputTo command? What's the fix for this problem if I really want to automatically export report in "1997-2003" format?
Thanks a lot!