build custom library 1

[chilly442]

Is it possible to build a custom library (.dll) for Excel? If so can someone point me in the right direction?

Thanks,
chilly442

 

[fumei]

Yes.

VB (not VBA) can make DLL files.

Gerry

 

[chilly442]

So build it in VB and then use it in VBA? Do you have an example or a site that I can use as a reference/How to?

Thanks,
Chilly442

 

[fumei]

You build the DLL in VB (make it a DLL project).

Compile it.

Register it using Regsvr32.

Once registered, you can use it by adding a reference to it in VBA.

"Do you have an example or a site that I can use as a reference/How to?"

Try googling.

BTW: other programming languages can build DLL files, not just VB.

Gerry