Call Excel COM Addins functions using macro

Question

How can I call a function defined in a COM Addin using excel macro ? Basically I have created a Excel COM Addin which does some bunch of stuff. Now I want to invoke this via excel macros. Is it possible to do it ?

Or

Is it possible to install COM Addin using a macro ?

Matthew Rathbone · Accepted Answer · 2009-12-30 02:06:59Z

1

You can reference COM libraries in the VBA editor by going to tools -> references (I think) then you can select (or browse for) whatever DLL you've created. When you've selected it there you can use the functions contained within in the usual way.

You should see a big list of libraries to select from.

When I've done VBA development in the past I normally end up using a few things like the Microsoft XML libraries through this method.

answered Dec 30, 2009 at 2:06

Matthew Rathbone

8,2897 gold badges56 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ankit Over a year ago

But this will create a new instance of the addin. I want to call a function of addin already loaded into excel without creating its another instance

Collectives™ on Stack Overflow

Call Excel COM Addins functions using macro

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related