Activating a VB6 created dll in VBA

[Jason Charalambides]

Hello,
I have just created a dll (myown.dll) that I want to activate in other
applications that carry VBA (let's say Excel).
I have gone into the VBA and created a form in which I have a button to use
as a command to activate the dll.
What do I need to do from here?
What is the command that I need to write in the area I have the XXXX:
Private Sub Execute_Click()
XXXXXX
End Sub
Do I need to make a new module for this or something?
Thank you for the help.
J.C.

 

[Harold Kless]

Hi J.C.
Usually the custom dll is reference in Tools References.
Once there is a reference established you can call the functions in the
project.
for example you might do something like this:
dim myDll as myown '(which could be the name of the myown.dll as shown in
the References dialog)
dim x
set myDll as new myown
(from this point it's a matter of calling the functions from the dll)
x = myDll.myFunction(y,z)


--
Harold Kless, MCSD
Support Professional
Microsoft Technical Support for Business Applications
(e-mail address removed)

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.