Â
Hi guys,
I am a Delphi user and I would like to pass on some of Delphi’s functionality to excel, the problem is how I add some of Delphi’s functions to excel. I understand that excel does not provide many programming options but I would like to create a Delphi dll for excel by compiling some of my Delphi functions.
If anyone can help me on this please reply to this post.
| Â |
Hi, You would first start by registering the DLL you created so that Excel loads it automatically as an add-in. Then use a COM object to that should be easily accepted by Excel once your code is compiled. Add-in Express provides a perfect framework and suitable components for this situation. It would be advantageous for you to go through it. It is a relatively easy step through process that will ensure that you need not bother with IDTExtensibility2.However, this comes at a price. Moreover, when you implement a COM add-in you will be required to make an automation DLL and employ an interface from IDTExtensibility2. An interface for your excel application will then come up that you will use as a parameter to this OnConnection method. |
Â
