ExcelBanter

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

matt

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


All times are GMT +1. The time now is 10:39 PM.

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