Sullivan,
While I'm not an expert at this, I have gotten it to work
on one application. First, compile your
VB 6.0
application as a DLL. Next, reference this DLL from your
VBA using Tools\References\Browse.
To call functions within VBA, use functions as follows:
Dim MyObj As Object
Dim result As Double
'Create object.
Set port_str = CreateObject("MyReference.MyClass")
result = port_str.MyFunction(parameters_passed)
Give this setup a try and see if you have any luck.
Steve
-----Original Message-----
Hey all
I'm working on a project that will require me to link to
an application that was created in standard VB 6.0 (NOT
VBA) while in VBA. Is this possible? And if it is, can
you let me know how it's done????
Thanks in advance
Sullivan
.