DoCmd.OutputTo Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 20 Dec 2005 21:37 GMT

When I run the following command to export data to Excel, I get the following
error message when I open the Excel spreadsheet. "File Error. Some number
formats may have been lost."

The command is:

DoCmd.OutputTo acOutputQuery, "qryGetMasterFromCriteria", acFormatXLS,
strExportLocation

Any ideas?

Signature

David

Reply to this Message

fredg - 20 Dec 2005 22:30 GMT

> When I run the following command to export data to Excel, I get the following
> error message when I open the Excel spreadsheet. "File Error. Some number
[quoted text clipped - 6 lines]
>
> Any ideas?

Haven't a clue.
But try the TransferSpreadsheet method and see it that works without
the error..

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97,
"qryGetMasterFromCriteria", strExportLocation,True

Look it up in VBA help for all of the arguments.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message