Syntax help with TransferSpreadsheet

  • Thread starter Thread starter chemicals
  • Start date Start date
C

chemicals

Here is my code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"get_materials", modInit.strOutputPath & modInit.ContractCode &
"_MaterialsList.xls", True
"get_materials" is a query.

I get the follwoing message: Can't find the object 'get_materials'.
If I look in the queries section it is there and it is spelled
correctly...?????
 
Back
Top