Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Owner2229
in reply to: Anonymous

"GoExcel" just like "Microsoft.Office.Interop" uses the Office library file (DLL) to control Excel.

It looks into registers and gets the DLL location from there. Sometimes it may happen (somehow) the location stored in registers becomes invalid.

It might be due to poor un/instalation of the program or just some kind of error.

 

The sample I gave you "CreateObject("Excel.Application")" is also using registers, but it's not looking for the Interop library but rather directly at the registered Excel application. If you'll instal multiple Office versions the last runned one will be the one that will open using this code.

 

Consider using "Accept as Solution" / "Kudos" if you find this helpful.
- - - - - - - - - - - - - - -
Regards,
Mike

"Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live." - John F. Woods