I need help - I can help - Non ActiveX DLL and VBA/MS Access

Print Page | Close Window

Non ActiveX DLL and VBA/MS Access

Printed From: Debenu Quick PDF Library - PDF SDK Community Forum
Category: For Users of the Library
Forum Name: I need help - I can help
Forum Description: Problems and solutions while programming with the Debenu Quick PDF Library and Debenu PDF Viewer SDK
URL: http://www.quickpdf.org/forum/forum_posts.asp?TID=2053
Printed Date: 27 Jun 25 at 12:18PM
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com

Topic: Non ActiveX DLL and VBA/MS Access

Posted By: researchassist
Subject: Non ActiveX DLL and VBA/MS Access
Date Posted: 23 Nov 11 at 10:38AM

Hi,

we are about to develop a programm that has to run in an environment without admin privileges, so we won't be able to register the ActiveX-DLL.

Is it possible to use the non ActiveX-DLL in our VBA-program?

Greeting

CHris

Replies:

Posted By: Ingo
Date Posted: 23 Nov 11 at 6:47PM

Hi Chris!

ActiveX is the better solution but a non-ActiveX-dll works in the described environment, too.
VBA doesn't have problems calling a "normal" dll put the dll in the same directory where your app is and it will work ... and i should know it ;-)
If you need things about how to call please post it here.

Cheers and welcome here,
Ingo

Posted By: researchassist
Date Posted: 24 Nov 11 at 2:22PM

Hi Ingo,

thanks for the answer. Could it be possible to use the ActiveX-DLL without registering it? Or is it better to use the other?

Ingo wrote:

If you need things about how to call please post it here.

It would be great if you could help us out here. Thank you.

Best regards

CHris

Posted By: Wheeley
Date Posted: 26 Nov 11 at 2:21AM

You can't use the activex dll without registering it. You need to use the regular non-actives dll if you are going to. The calling program entry points are different between the 2.

Wheeley

Posted By: AndrewC
Date Posted: 26 Nov 11 at 12:10PM

I have worked on for some time.

It is possible to link and load to the standard QPL DLL version but I cannot get strings to pass to and from the library successfully.

I can get VBA to load the standard DLL and calling CreateLibrary seems to work. Call QP.UnlockKey fails. I have tried all combinations of ByRef, ByVal, String, Variant ... using QP.UnlockKeyA ... but the strings returned by QPL are always empty. It could be because the strings may actually be BSTR's.

Posted By: researchassist
Date Posted: 30 Nov 11 at 12:59PM

Hi,

anybody any ideas?

Help is greatly appreciated.

Best regards

CHris