PDA

View Full Version : Creating Add-ins



naikosen
07-05-2008, 07:57 PM
Is it possible to create Excel Add-Ins in a shape of .dll?
If Yes, please suggest me the way to create it.

Bob Phillips
07-06-2008, 02:10 AM
I personally have no idea what you mean by ... in a shape of .dll? You can certainly create COM addins in VB6.

naikosen
07-06-2008, 06:29 PM
Thank you very much 'XLD'

Excel add-ins are created with extension '.xla'. I want to get the same result making a Com addin using VB6. But don't know how to create.

Here is a user function to be used freely in Excel:


Function Message()
MsgBox "Thank you very much"
End Function


I want to get that function coded in a Com Add-Ins using VB6 so that it can be used in Excel.

Bob Phillips
07-06-2008, 11:56 PM
First of all, do you have VB6?

Secondly, have you ever you used it? Do you know how to create dlls with VB6?

naikosen
07-09-2008, 05:14 PM
First of all, do you have VB6?

Secondly, have you ever you used it? Do you know how to create dlls with VB6?

I know to create dlls with vb6.

The only thing I am stumbled over is the way to use the code as mentioned above in the dll. So that the function =Message() can be invoked in any excel worksheet at any time by the user to display the message "Thank you very much".

I have compiled the function in xla and found working, but I want to know the way to compile the same function in dll using vb6.

naikosen
07-10-2008, 05:42 PM
Is what I want to know not possible?

JKwan
07-11-2008, 08:24 AM
Here try this link, this should show you exactly what you want to do.
http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

naikosen
07-12-2008, 06:13 PM
Thank you very much JKwan.
Problem solved