Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Sharing Excel Macros across files
Name: LouSharon Date: April 7, 2005 at 08:52:41 Pacific OS: Win2k SP4 CPU/Ram: Pentium 2.8 ghz/515,568 k
Comment:
Hi All,
With MS Word my VB macros are available in all my documents, not true with Excel Workbooks.
Is there a way to make my Excel VB macros available to multiple workbooks without doing a copy/paste?
Name: Grok Lobster Date: April 7, 2005 at 10:21:44 Pacific
Reply:
They should be available. Is your macroworkbook in the XLStart folder? Are the macros general enough to run on whatever the active workbook is?
0
Response Number 2
Name: LouSharon Date: April 7, 2005 at 11:19:41 Pacific
Reply:
Hi Grok,
Thanks for your reply!
Are the macros general enough to run on whatever the active workbook is? Yes, definately!
Is your macroworkbook in the XLStart folder? Not sure what you mean by this. I started a new workbook saved it on a network drive. I wrote a couple of macros and thought that it would be really useful if they were available to other workbooks I may create in the future.
I just Googled macroworkbook and it looks like I can find what I need to set this up.
Thanks
Lou
0
Response Number 3
Name: Bryco Date: April 7, 2005 at 13:58:29 Pacific
Reply:
When creating a macro you have the option to save it to the Personal workbook that makes them available all the time for the user.
You can also open the workbook that contains the macro to make it available in other open workbooks.
HTH Bryan
0
Response Number 4
Name: LouSharon Date: April 7, 2005 at 17:01:23 Pacific
Reply:
Thanks Grok and Bryan! I managed to get it working without very much difficulty.
Here are the links I found helpful in case someone else is looking
Summary: Dear All, I would like to copy and paste my file(Any type) from one drive to another. For example: I have 10 files in c:\eliaz\Deal1 to d:\deals done using macro. Files may be of any type such as pdf,...
Summary: I'm looking for some help running an excel macro as an automated task. The macro is supposed to create a data connection, import some data from a particular database, apply some formatting and formul...
Summary: Hi Steve. If you open Excel without selecting a file, and your PERSONAL.XLS opens up, simply select "Window->Hide" from the menu bar, and close Excel, saving the file. Then, at all future Excel sessio...