How to reference the DLL in VBA?

Mar 1, 2012 at 7:59 AM

Hi, I have a problem when reference the DLL in Excel.

The message is "Can't add a reference to the specified file." when I used Tool-->Reference in Excel

Then I tried to register the DLL file, but there was another problem like "AlexPilotti.FTPS.Client.dll was loaded, but the DllRegisterServer entry point was not found. This file can not be registered."

Is there any document about the entry point of the DLL or could you please help me on this problem?

Thanks in advance!

Coordinator
Mar 1, 2012 at 3:52 PM

Hi,

in order to use it in VBA, you need a COM object. It could be possible to write a wrapper on top of the DLL or to enable the COM interop features in the assembly.

I'm going to evaluate it.

 

Best,

Alessandro