export using transferspreadsheet

  • Thread starter Thread starter CDM
  • Start date Start date
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.
 
Back
Top