Using External ActiveX files in the VBA Environment

RFgen allows the incorporation of external ActiveX .EXE or .DLL modules by declaring an Object and using the CreateObject method.

(missing or bad snippet)

Dim MyObject As Object

Set MyObject = CreateObject("name.cls")

' name is the name of the ActiveX module

' subsequent usage

MyObject.property

MyObject.method

The syntax is slightly different when using a DLL compiled using Visual Basic.

Dim MyDLL As Object

Set MyDLL = CreateObject("ourDDC.DDCcom")

Where: ourDDC is the executable name DDCcom is the public class name containing the functions you wish to call.