Problems with XLS file Generated by OutputTo Method

[dougcoulter]

I am trying to export a couple of reports to Excel using the DoCmd.OutputTo method of Access 2002. It appears to work fine, but when I try to open the XLS file, Excel crashes. I have tried opening it on several different PCs with different versions of Excel. I have also checked out Microsoft's Knowledge Base to no avail. Has anyone else seen this problem?

 

[befree]

Try using this alternate command:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, WrkTbl, ExportFile

Where Wrktbl is the variable holding the tablename and Exportfile is the variable holding the destination & output name.

Using excel97 type make it more portable.

 

[dougcoulter]

Thanks a bunch befree. I will give this a try ASAP.

 

[dougcoulter]

It appears the TransferSpreadsheet method works only with tables and queries as opposed to reports (?)

I did play a little more with the OutputTo method, and it seems the XLS file generated locks up due to some simple aggregates (summations) on sections (i.e. group aggregates and report aggregates). When I remove them from the report and run my function, the generated XLS file works just fine. Unfortunately, I need the aggregates!