export using transferspreadsheet

C

CDM

I'm getting an error message from the following transferSpreadSheet command
that says "Can't find the object named 'qryRptOver60Days'. Here is the line
causing the error:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"qryRptOver60Days", "\\MyPath\MyWkBook.xls" ' "Over 60"

I can bring up the query and work with it in Access forms and reports, could
this be a Jet problem?

Thanks in advance for your help.
 

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

Odd TransferSpreadsheet error msg 3125; $ not a valid name 7
Syntax help with TransferSpreadsheet 1
TransferSpreadsheet to Excel limit 5
Variable in TransferSpreadsheet method 4
TransferSpreadsheet method question 2
Export Report to Excel using TransferSpreadsheet 1
Export Report with Graph to Excel error 2495 1
output to, transferspreadsheet, or excel automation? 2

Top