ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Method 'COMAddIns' of object '_Application' failed (https://www.excelbanter.com/excel-programming/321433-method-comaddins-object-_application-failed.html)

Samko

Method 'COMAddIns' of object '_Application' failed
 
Hi,
I'm getting this error when I try to work with COMAddIns in VBA in Excel
2003. I have referenced the project to Microsoft Office 11 Object Library as
stated that I should, but I'm still getting the error. It looks like VBA
knows about the COMAddIns object, but for some reason it still doesn't like
it. Statement as simple as:

Application.COMAddIns.Update

would cause the error to pop up.

If anybody has an idea, I would appreciate it a lot.

Thanks...


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com