Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

creating a dll


I´m creating a dll in vb to use after in vba. When in VBA I use Private Declare Function name Lib "xx" () as string

It tells me when I call to that function that it doesn´t found the dll.

I have read in some articles made by Ron Petrusha that you can´t do this, that you must change the link.exe and create after a .def file.

I know that I would use the dll importing in references the dll and calling this function. But I don´t want to do this.

Has anyone change the link.exe file ?¿?
1 Solution
Carl TawnSystems and Integration DeveloperCommented:
You don't need to use declare for DLL's created with VB, they are ActiveX. As long as the DLL is registered on the machine you can create an object of a class contained within it by simply using:

   Set obj = CreateObject("YourProject.YourClass")

Or, if you add a reference:

   Set obj = new YourProject.YourClass

Hope this helps.
1469Author Commented:
Yes but the problem here it´s that I have to registry if I have in a pc the dll in one path and the other in other path ¿?¿? I guess that is easier to have a common dll than this stuff

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now