calling functions of a COM-Add-In from VBA-code

[Meier Rudolf]

Hi

Is it possible to call a function from a COM-Add-In in my VBA-code?

MR

 

[Steve]

Yes it is. If you have a reference to your COM object you would just treat
it like any other object in VBA. I would recommend that you late bind to
your COM object (Dim X as Object: Set X = CreateObject("My.GUID")) so that
you don't have to worry about distrabution being broken by changes in GUID
values.

~Smitch