Using and working with delphi dll for excel

Asked By 30 points N/A Posted on -
qa-featured

 

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.

SHARE
Answered By 0 points N/A #142983

Using and working with delphi dll for excel

qa-featured
 

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.

 

Login/Register to Answer

Related Questions