Calling VBA class modules from a COM add-in written in ATL/C

[Mousam]

Hi All,
I am developing an Excel COM add-in using C/C++. I am having an
Excel add in which is developed using VBA and in my add-in I want to
use functionality of VBA add-in. This VBA add-in is having some class
modules and I want to use functionalities of these class modules in my
COM add-in.

I want to know is there any way to use functionalities of class
modules inside VBA in some other COM add-in?
I know we can call functions and macros written in VBA from other COM
add-in using "Run" method of "Application" object but how can we call
functions of class written in VBA from other COM add-in?

Any help or pointer would be much appreciated.

Thanks & Regards,
Mousam Dubey

 

[Mousam]

Hi All,
I am developing an Excel COM add-in using C/C++. I am having an
Excel add in which is developed using VBA and in my add-in I want to
use functionality of VBA add-in. This VBA add-in is having some class
modules and I want to use functionalities of these class modules in my
COM add-in.

I want to know is there any way to use functionalities of class
modules inside VBA in some other COM add-in?
I know we can call functions and macros written in VBA from other COM
add-in using "Run" method of "Application" object but how can we call
functions of class written in VBA from other COM add-in?

Any help or pointer would be much appreciated.

Thanks & Regards,
Mousam Dubey

Hi All,
I found the solution for this problem on following link.

"How to use a class (object) from outside of the VBA project in which
it is declared
http://support.microsoft.com/kb/555159"

Thanks & Regards,
Mousam Dubey