Syntax help with TransferSpreadsheet

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...?????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export using transferspreadsheet 1
TransferSpreadsheet saving file 11
Variable in TransferSpreadsheet method 4
Export Report to Excel using TransferSpreadsheet 1
output to, transferspreadsheet, or excel automation? 2
TransferSpreadsheet method question 2
Syntax for TransferSpreadsheet method 4
expected format 3

Top