View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
matt matt is offline
external usenet poster
 
Posts: 2
Default 1004 method 'COMAddIns' of object '_Application' failed

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