Excel calling external Dll

Hi there

Hope everybody is fine !

I have following problem

- I have an excel file that calls an external dll for calculation
This file works fine on my PC

- I have sent this file with VB code protected to another user, that has a copy of this identical dll.

The problem is that the file loses the reference to this dll, and does not work.

It would be needed to go into VB, references and to select the called dll, but this can't be done, since the file is protected.

Is there a way to send this file with protection and avoiding it to lose the dll reference ?

Many thanks

Did you not put the file into the system32 folder for both computers?

Greetings,

Advice:

Go to your workbook where you have the reference and then go to your VBA Editor and check only the external reference (your DLL).

then run this code:

Please Login or Register  to view this content.

If you get error running the code, go to: File -> Options -> Trust Center -> Trust Center Settings -> Trust Access to VBA Project

After that you should have the GUID of the DLL you need like this:

Please Login or Register  to view this content.

If you need to register the DLL into the Reference Library then you can use this function in a module:

Please Login or Register  to view this content.

Then run this Sub in a Module:

Please Login or Register  to view this content.

With this in mind, in your Open Workbook Event write this code:

Please Login or Register  to view this content.

Between the {} put the GUID that shows in your Immediate window.

Hope it helps,
Daniel