feathers212
12-18-2006, 07:33 AM
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!!
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!!