Running/storing macros independently of worksheet

[feathers212]

I have created three macros (the macros call each other, so they could technically be linked together as one macro if necessary). The macros are stored as modules in a random worksheet designed just to store the coding (let's call it the "Code File").

The macros are designed to manipulate data that is pulled from our intranet into an Excel file (call it the "Pulled Data File"). Currently, for my own testing purposes, I have the "Code File" open and run its macros in the "Pulled Data File".

Is there a way that I can have the coding run in the "Pulled Data File" without needing to have the "Code File" open? Is there a way to create either a menu or unique toolbar button that would enable this set of macros to run? I need to have this process be as user friendly as possible for the guys who don't know all that much about Excel, let alone all of the macro/VBA capabilities.

I know I have seen this type of thing done in the past, but I was only a user of the process myself at that time. Now, I'm just stuck:help

Thanks for your help!!

[gnod]

i think you need to create an add-in for your code file..

[feathers212]

i think you need to create an add-in for your code file..

Yea, after a little more research, that's what I've determined that needs to be done. Does anyone have any good information on how to create add-ins? This is something totally new to me. I need to make it easy to make updates to the add-in though as it is something that will be used across several computers (may need to do updates, depending on end requirements).

Thanks for replying gnod!:hi:

[gnod]

maybe this site can help you..

http://www.ozgrid.com/VBA/excel-add-in-create.htm
http://www.excelguru.ca/node/45

[Bob Phillips]

http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

[johnske]

You could also do this with the code kept in Personal.xls or in a separate workbook kept in the XLSTART folder - more (http://www.vbaexpress.com/forum/showthread.php?t=9747)

[Zack Barresse]

Check out this recent thread as well...

http://www.vbaexpress.com/forum/showthread.php?t=10592