DoCmd.TransferSpreadsheet acExport

[IanT]

Hi

I am using this code to transfer data to a excel sheet:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"if - Property MLT Actual Recovery", "T:\Shared\Claims Supply\Management Information\CIU\CIU Mark\New\Property Claims Fraud Report.xls"

The code names the worksheet 'if - Property MLT Actual Recovery', is it possible to change the code so I can name the worksheet to Actual Recovery! I cannot change the query name!

Thanks in advance......

 

[Guus2005]

Create a query called "Actual Recovery". The contents of the query:

Select * from "if - Property MLT Actual Recovery"

Remove the asterisk and use actual fieldnames to set the fields in the right sequence. Use query "Actual Recovery" in your TransferSpreadsheet statement.