Hi,
I'm trying to use my AddIn in Excel to create some reports. In Excell 2003, VBA editor, when I try to use COMAddIns I get "Method 'COMAddIns' of object '_Application' failed". It looks like VBA understands COMAddIns object, but when I want to use it I'm getting this error. Following statement would cause it:
Application.COMAddIns.Update
I do include the reference to Microsoft Office 11.0 Object Library as it is stated I should do, but still getting the error.
I've looked everywhere. Other people are talking about this error, but no solutions. If anybody has the idea on what I should do to make it work, I would appreciate it a lot.
Thanks...
Bookmarks