Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

How to Make Excel Add-in ?

ranainnetranainnet Posts: 54Member
I can write macros in Ms-Excel by using VBA. But to make my macros useable to others and at the same time to protect my code I have to put password in the macro so that no other can see the code without the password and give the .xls file to that person for work.

The process seems to me very basic. Now I want to make Add-ins for Excel, in vb6 there is a option to make Add-in for Excel, But I do not know how to make an add-in for excel.

So Will anybody please help me and tell me how to program a Excel Add-in ???????????????
_____________________________________________________________________________
Knowledge Is Power. Be Sure To Use This Power For Others WelFare. (;->

Comments

  • PavlinIIPavlinII Posts: 404Member
    : I can write macros in Ms-Excel by using VBA. But to make my macros useable to others and at the same time to protect my code I have to put password in the macro so that no other can see the code without the password and give the .xls file to that person for work.
    :
    : The process seems to me very basic. Now I want to make Add-ins for Excel, in vb6 there is a option to make Add-in for Excel, But I do not know how to make an add-in for excel.
    :
    : So Will anybody please help me and tell me how to program a Excel Add-in ???????????????
    : _____________________________________________________________________________
    : Knowledge Is Power. Be Sure To Use This Power For Others WelFare. (;->
    :
    Hi,
    I'm not sure if add-in is exactly what you need and what would work as you need.
    You can make you own library, control library, active x.. blablabla etc.. Let's say own.DLL with some public methods, compile it and make reference to it form your project..
    In your xls file will be just one (or more) modules with imported functions of your dll and used.. (Too few code for anyone to stole).
    This DLL can be made in any language, but you can not make and compile theese in VBA (Excel), you need visual studio for this.

    [blue][b][italic][size=4]P[/size]avlin [size=4]II[/italic][/size][/b][/blue]

    [purple]Don't take life too seriously anyway you won't escape alive from it![/purple]


  • ranainnetranainnet Posts: 54Member
    Thank U for your reply,

    I really do need to know "how to make MsExcel add-in" by using VB6. I am a student of MBA finance and I have to do a lot of forcasting and simulation works in excel.

    I've found some programs in the net that does my works very easily but unfortunately all of them are trial vertions and I couldn't even find out any crack or serials for them.

    So I dicided to make my own simulation program that will work in the same way as other programs like CRYSTAL BALL do.

    While looking at the VBA of a new excel document I have also seen that CRYSTAL REPORT (a report generation program) also works in the same way (after installing CRYATAL REPORT it automatically adds an add-in for excel and then I can use the functions of CRYATAL REPORT form within the excel environment).

    So in bried what I am looking for is how can I make add-in for excel.
    _____________________________________________________________________________
    Knowledge Is Power. Be Sure To Use This Power For Others WelFare. (;->

  • PavlinIIPavlinII Posts: 404Member
    : Thank U for your reply,
    :
    : I really do need to know "how to make MsExcel add-in" by using VB6. I am a student of MBA finance and I have to do a lot of forcasting and simulation works in excel.
    :
    : I've found some programs in the net that does my works very easily but unfortunately all of them are trial vertions and I couldn't even find out any crack or serials for them.
    :
    : So I dicided to make my own simulation program that will work in the same way as other programs like CRYSTAL BALL do.
    :
    : While looking at the VBA of a new excel document I have also seen that CRYSTAL REPORT (a report generation program) also works in the same way (after installing CRYATAL REPORT it automatically adds an add-in for excel and then I can use the functions of CRYATAL REPORT form within the excel environment).
    :
    : So in bried what I am looking for is how can I make add-in for excel.
    : _____________________________________________________________________________
    : Knowledge Is Power. Be Sure To Use This Power For Others WelFare. (;->
    :
    :
    Hi again.
    To make classic add-in, open excel, make some macros (fill File/Properties..Summary to give it a name and description) and click File/Save As.. Choose Excel Add-In (*.xla) - it's the last one in my combobox.
    Now, we've got real Excel Add-In. But your code could be protected by password, but it is NOT secure (I guess you know this and it's the reason why you want to use VB6).
    So, let's join VB6 to this solution.
    Start it, create new project and choose DLL or Addin. Addin should work better with your solution, but DLL would work also.
    Vistual studio will make frmAddIn for you with basic methods. You can extend it's functionality in any way you need. Ten compile it into IDontKnowWhat.dll
    Open VBA editor in your XLA file, Tools/References and find your IDontKnowWhat.dll. Now, your "real" code is compiled into that DLL file (and protected), and you have excel add in (XLA), which you can use. Your VBA code will contains only "interface" calls to your DLL file, so nobody will not be able to explore your real code.

    Hope this helps

    [blue][b][italic][size=4]P[/size]avlin [size=4]II[/italic][/size][/b][/blue]

    [purple]Don't take life too seriously anyway you won't escape alive from it![/purple]


  • ranainnetranainnet Posts: 54Member
    Thank U for your reply Pavlin II,

    I m sorry 4 my laye reply to ur message. Your info will be a great help to me. If u come to know any URL where I may get articles on making professional Excel Addins then please let me know it.

    Hope to here from u soon. Bye.
    _____________________________________________________________________________
    Knowledge Is Power. Be Sure To Use This Power For Others WelFare. (;->

Sign In or Register to comment.