Using and working with delphi dll for excel

Asked By Bertha Griffen 30 points N/A Posted on - 05/03/2013

 

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.

• Status: Open
• Question Views: 939
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Carr Woodberry 5 points N/A #142983

Using and working with delphi dll for excel

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.

 

About Carr Woodberry

Questions
0

Answers
23

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 05/10/2013
• Question Category: Misc Software