Fix for Excel VBA error when library not found.
Screenshots should show how to fix.
Last screenshot suggests restoring references
Basically, we need to restore all references that may get lost due to some updates.
Fix Excel issue
Macros not running saying Project not found, then VBE > Tools > Resources window is open asking for references.
Fix:
Re-select the library that is missing, HOW do we know what is missing?
Open workbook in a machine where it was working fine and get a list of needed resources from there.
If that is not possible, then read and understand the code and see what is the possible library that was used and select its reference again
Save, close and try again.
Fix Excel issue
Macros not running saying Project not found, then VBE > Tools > Resources window is open asking for references.
Fix:
Re-select the library that is missing, HOW do we know what is missing?
Open workbook in a machine where it was working fine and get a list of needed resources from there.
If that is not possible, then read and understand the code and see what is the possible library that was used and select its reference again
Save, close and try again.
Views 185
Downloads 60
CodeID
DB ID