OutputTo method using acFormatXLS argument 5.0/95 format only?

J

Jim D.

My Access 2000 runtime based application automatically outputs reports to Excel format using this code

DoCmd.OutputTo acOutputReport, , acFormatXLS, myfile.xl

The spreadsheet file that is saved is Excel 5.0/95 version. Is there a way to have this be Excel 97/2000 version

I have tried modifying this registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Access\Report Formats\Microsoft Excel to have the same Data as the report format for Excel 97/2000, the OutputTo command fails and the error says, "The formats that enable you to output data as Microsoft Excel are missing from the Windows Registry". Is there another registry entry that I must change

Thanks in advance for the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 acFormatXLS not working 7
DoCmd.OutputTo acOutputQuery acFormatXLS to 97-2003 not 2005 2
Problem with acFormatXLS 0
Some of the sum totals are exporting to Excel 0
OutputTo PDF error 2501 The OutputTo action was cancelled 1
Emailing a report in Excel format 0
convert Microsoft Excel 5.0/95 to ms excel 2003 6
TransferSpreadsheet and Percent format 0

Top