export using transferspreadsheet

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

 

[Jerry Whittle]

It looks like you have a ' instead of a , over near "Over 60"