1004 method 'COMAddIns' of object '_Application' failed

M

matt

I am trying to use the comaddins object to load and unload some addins
it works great in XL 2000 and 2003 but not XP (2002). When ever I try
to access the comaddins object I get the error: 1004 method
'COMAddIns' of object '_Application' failed.

on line of code will cause it

sub test()
Application.ComAddIns.Update
end sub
 

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

Top