Overview
When starting Excel 2003 with a supporting version of the Jet Excel add-in installed or attempting to run a Jet report, Visual Basic Run Time Error 438 can be displayed:
Complete text of error message is:
Run-time error '438: Object doesn't support this property for method
Cause:
This error is often caused by Excel 2003 "losing" or "corrupting" registry entries needed to access the the Jet Excel add-in. This can be resolved by manually re-adding the Jet Excel add-in to Excel.
Resolution Process
-
Start Excel
-
Select Addins from the Tools menu
-
Click the Browse button
-
Navigate to C:\Program Files (x86)\Jetreports
-
Select the Jetreports.xla file
-
Click OK
if you receive a prompt to overwrite, click Yes
The Jet Excel add-in should now be re-added.
Comments