Hello All,
I am using Access 2000. I am using the feature TransferSpreadsheet and if the path of the spreadsheet is
present then the database works fine. If the spreadsheet
path is not the same I get the VBA Run-time error as such:
Run-time error '3011'
the Microsoft Jet database engine could not find the object
'C:\TBLCLINETBLANK.XLS'. Make sure the object exists and that
you spell its name and the path name correctly.
How can I fix this problem with a message for the user to
ensure that the spreadsheet path is present at the designated
location. Thanks in advance for assistance.
I am using Access 2000. I am using the feature TransferSpreadsheet and if the path of the spreadsheet is
present then the database works fine. If the spreadsheet
path is not the same I get the VBA Run-time error as such:
Run-time error '3011'
the Microsoft Jet database engine could not find the object
'C:\TBLCLINETBLANK.XLS'. Make sure the object exists and that
you spell its name and the path name correctly.
How can I fix this problem with a message for the user to
ensure that the spreadsheet path is present at the designated
location. Thanks in advance for assistance.