Run Time Error 438 - Object Doesn't Support this Property or Method
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.