Solution to DLL loading errors in VBA

 

Solution to DLL loading errors in VBA

When you open the Excel file, this error occurs. From the VBA tool> reference, there will be lost xxx.

 

This is because the reference path is faulty.
1. Prohibit the use of macros first. Otherwise, the macro cannot be deleted when the reference is deleted.
2. In the reference, the DLL that does not find the target file is displayed. Delete the DLL file and remember the path before deleting it.
3. Find the DLL again based on the path you just remembered and add it ~~
(I have no idea why the file exists in the path, but VBA cannot recognize it. I have to delete it and add it again !)