How does one load/unload a COM AddIn via code (Excel 2000/Excel 2002)

Topic

New Reply

How does one load and unload an Excel COM AddIn via code such as VBA, as we do not wish to have the COM addin loading on startup of every Excel application?

Reply | Quote

Replies

Jim

Wow this question has gone on for so long unanswered, that means people here did not see it, or don’t know the real answer YET!!!

But I found this MSDN article for you, check it out and let me know if it helps.

Check the section on Choosing Development Tools where it says:

<<>>

The Load behavior settings include Load on Demand and Load at Next Startup Only, so maybe this is the area you want to look into.

HTH

Wassim

Reply | Quote

Thanks! Yea I know about the MSN article and the Designer interface where you select how the COM Addin is loaded but that is as far as the dicussion goes as there is no example of how to load in on demand other than via a toolbar or menu item. Even then responding to the toolbar or menu load event there is no explanation of how the COM Addin is loaded via code. The reason we want to load on demand is becuase if a COM AddIn is set to load on startup then that COM AddIn is loaded for every Excel started application, even for applications where one would not desire that COM AddIn to be loaded.

Reply | Quote

Jim,

…
HOWTO: Install an Excel Add-In (XLA or XLL) with Automation
The information in this article applies to:
Microsoft Excel 2000
Microsoft Excel 97 for Windows
Microsoft Visual Basic Professional Edition for Windows 6.0
Microsoft Visual Basic Enterprise Edition for Windows 6.0
Microsoft Excel 2002…

http://”%5Dhttp://support.microsoft.com/?kbid=280290″>http:// http://support.microsoft.com/?kbid=280290[/url]

Regards,

Jim Cone
San Francisco, CA

Reply | Quote

Thanks. What the article refers to are xla and xll type addins but what I am asking about is loading a COM AddIn via code.

Reply | Quote

The code would be

Application.COMAddIns("ccc.ddd").Connect = True

where ccc is the name of your addin, ie ccc.dll
and ddd is the name of your Designer

Reply | Quote

The URL for Q280290, Install an Excel Add-In (XLA or XLL) with Automation, referenced above should be http://support.microsoft.com/default.aspx?…kb;en-us;280290%5B/url%5D. It’s excellent, thanks Wassim and Jim Cone!

Reply | Quote

See also http://support.microsoft.com/default.aspx?…kb;en-us;256624%5B/url%5D

Reply | Quote