Method 'COMAddIns' of object '_Application' failed

G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

1004 method 'COMAddIns' of object '_Application' failed 0
Run time error 50290 method 'ontime' of object '_application' failed 0
Method 'OnTime' of object'_Application failed 3
Do I need DLL or COM Addin, Excel Addin 1
method 'run' of object '_application' failed 3
Method 'Display Alerts' of object '_Application' failed 2
Error when opening Embedded Excel File in Word 1
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15

Top