Creating Add-ins

[naikosen]

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]

I personally have no idea what you mean by ... in a shape of .dll? You can certainly create COM addins in VB6.

[naikosen]

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:

[vba]
Function Message()
MsgBox "Thank you very much"
End Function
[/vba]

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

[Bob Phillips]

First of all, do you have VB6?

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

[naikosen]

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]

Is what I want to know not possible?

[JKwan]

Here try this link, this should show you exactly what you want to do.
http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

[naikosen]

Thank you very much JKwan.
Problem solved