Error 3011 Jet could not find object empty string

[EdF4]

Hi. I couldn't find anything on this question searching here, nor anything useful on Google:

I have an Access 2003 database containing this line of code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "tblLeads", "c:\program files\telesales\LeadTable.xls", True

This line, and similar lines elsewhere, SOMETIMES produce Error #3011, The Microsoft Jet database engine could not find the object ''. That's right, it says '' where the name of the table it can't find should be. tblLeads definitely exists--it's a linked table, if that makes a difference.

How can I fix this problem?

Thanks.

[OBP]

EdF4, welcome to the Forum.
Are all of the Excel Workbooks of type Excel 97?

[EdF4]

Thanks OBP.

You know, the ones that occasionally (but not always) give us problems are of type Excel 97. They are probably just carryovers in this legacy code I'm using--originally written for Access 97.

But we have some that are type acSpreadsheetTypeExcel9 . I don't recall having any problems with those. And I believe everyone using this code actually has Excel 2003 or better.

Perhaps I should switch all of them to Excel 9, then?

[OBP]

I would certainly try it as Test with the user who has the most problems, I don't see how it can do any harm.
I can't really think of anything else that can cause that kind of error.

[EdF4]

Thanks. I'll definitely try it.