VBA Activex.dll?

[Aidy]

Is it possible to import a VBA class module and create a Activex.dll from it in VB?

Aidy

 

[Jonathan West]

Hi Aidy

The answer is a definite maybe.

Yes, you can export from VBA
Yes, you can import that class module into a VB6 ActiveX DLL project (Note,
not VB.NET, the syntax is different)
No, it might not work correctly without modification.

At least you will probably have to set a reference in the VB project to the
Office application (i.e. Word or Excel or whatever) the class was running
under.

If the class calls UserForms, then you might want to rewrite those as Forms.

 

[Karl E. Peterson]

Is it possible to import a VBA class module and create a Activex.dll from it
in VB?

Yes. It may be problematic, though, if the class module relies heavily on the Office
object model. If it's "just" VBA code, it should be dropdead simple.

 

[Aidy]

Is there another way of instantiating a VBA class from another COM
enabled product?

The class is in the object browser, but I am not sure of the object
hierarchy I follow?

Also in the object browser there is an 'Aproject' class with a
RunMacro method. Could I try to run the sub that instantiates the
class?

Aidy

 

[Jonathan West]

Is there another way of instantiating a VBA class from another COM
enabled product?

The class is in the object browser, but I am not sure of the object
hierarchy I follow?

Also in the object browser there is an 'Aproject' class with a
RunMacro method. Could I try to run the sub that instantiates the
class?

Lets take a step back here. Forget about instantiation & all the rest of it.
Describe what you class does and what you are trying to achieve overall. I
suspect there is an easier approach to all this.

Also could you let us know which Office application your VBA projects is
working in? The object models of the different Office applications are very
different from each other, and a solution that works for one might not work
for another.

 

[Aidy]

Also could you let us know which Office application your VBA projects is
working in?

I am trying to automatically test a Mainframe app through a terminal
emulator. The emulator has a vba scripting language built in. I have
referenced the emulator objects in Excel VBA so I have the power of
both VBA's.

I am using a class module because of this statement

"Private WithEvents m_ttHost As teemtalk.Host"

Thanks

Aidy