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
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.
Select Addins from the Tools menu
Click the Browse button
Navigate to C:\Program Files (x86)\Jetreports
Select the Jetreports.xla file
if you receive a prompt to overwrite, click Yes
The Jet Excel add-in should now be re-added.