The COM error code 0x80028029 translates to:
Invalid forward reference, or reference to uncompiled type
Sometimes you can get this error when trying to interact with an Excel workbook, resulting in an error like this one:
##RuntimeError: AttributeError: Worksheets (code=0x80028029)
But what does this error mean, and how can you fix it?
This error is typically caused by a corrupted Excel workbook. Usually it is some VBA code that has been saved as part of the workbook that's gone wrong.
If you have VBA code saved in your workbook you can try recompiling it in the VBA Editor by selecting "Compile VBAProject". Sometimes this is enough to fix the corruption.
If this doesn't work there are some other third party tools that you can try to rescue the workbook:
If nothing else works, create a new workbook and copy the data from the corrupted workbook to the new workbook. Once you have fixed (or replaced) the corrupted workbook the 0x80028029 error should be resolved.