R
rael_lucid
Hi,
I have an Access app on a few PCs with WinXP and OfficeXP SP3. One of the
functions of the app involves sending data from a table into an MS Excel
spreadsheet.
I do this with the following statement:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"TEMP_ExportBookings", "C:\Temp.xls", True
This code runs perfectly most of the time, but on one PC in particular, I
SOMETIMES get the following error:
Err.Number: 3011
Err.Description: The Microsoft Jet database engine could not find the object
''. Make sure the object exists and that you spell its name and the path
name correctly.
As menioned before, it runs perfectly on other machines.
Please help!!!
I have an Access app on a few PCs with WinXP and OfficeXP SP3. One of the
functions of the app involves sending data from a table into an MS Excel
spreadsheet.
I do this with the following statement:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"TEMP_ExportBookings", "C:\Temp.xls", True
This code runs perfectly most of the time, but on one PC in particular, I
SOMETIMES get the following error:
Err.Number: 3011
Err.Description: The Microsoft Jet database engine could not find the object
''. Make sure the object exists and that you spell its name and the path
name correctly.
As menioned before, it runs perfectly on other machines.
Please help!!!