Forum Discussion
Has Excel stopped working with visacomlib.dll (Oct 2021)
Managed to resolve the issue by uninstalling MS Office 365 the second time around from Programs and Features.
Going to my companies IT provided MS Office 365 portal (URL was something http://portal.office.com/ and logged in with my work email).
Clicking on the Install Office button and downloading a OfficeSetup.exe
Running the .exe to reinstall MS Office 365 applications with Administrator privileges
Reboot
Launch my Excel program with the VBA code referencing VISA-COM Library 5.12 and ran it without the crash anymore.
So the bug looks to be happening when the MS Office 365 was updated and it basically breaks the Exit Sub process when objects in the VBA program are supposed to be Garbage Collected.
Some other Keysight engineers managed to get some feedback from a Microsoft engineer. The following was the root cause of the crash so updating your MS Office version to the one release on January 27, 2022 and beyond should fix the issue.
About this problem, we had investigated the root cause with a Microsoft engineer and found the followings.
1) Excel uses the VBE7.dll to exeucte VBA program and the VBE7.dll, which file verstion is greater than or equal to 7.1.11.13 and less than or equal to 7.1.11.17, has a defect.
2) The defect is that the VBE7.dll cannot execute COMs without IDispatch interface.
3) VISA COM has an IUnknown interface, but it does not have the IDispatch interface, then VBE7.dll with the defect cannot executes the VISA COM.
4) The latest Office version, which was published at January 27 as the "Current Channel", has VBE7.dll file version 7.1.11.18 and the VBE7.dll can execute COMs without IDispatch interface.
Then the latest Excel can execute VISA COM.