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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.