Output To Excel defaults to version 5-7/want Excel 10

[Guest]

TIA:

In my code:
DoCmd.OutputTo acOutputQuery, "qryCNdataall", acFormatXLS, "c:\" & name &
".xls", False

The file is Excel 5-7 format.

How might I get the file saved as Excel 10?

Thanks,
Joel

 

[Rick Brandt]

TIA:

In my code:
DoCmd.OutputTo acOutputQuery, "qryCNdataall", acFormatXLS, "c:\" & name &
".xls", False

The file is Excel 5-7 format.

How might I get the file saved as Excel 10?

Use TransferSpreadsheet instead of OutputTo. TransferSpreadsheet allows you to
specify the Excel version.

 

[Guest]

Thanks but I believe I can only export tables and I am exported data from a
query...any other way other than having to create tables from query?

Joel

 

[Rick Brandt]

Thanks but I believe I can only export tables and I am exported data from a
query...any other way other than having to create tables from query?

The third argument for TransferSpreadsheet (TableName) is poorly named. You can
use it for exporting saved select queries as well.

 

[Guest]

Thanks for the insight...Joel

The third argument for TransferSpreadsheet (TableName) is poorly named. You can
use it for exporting saved select queries as well.