Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Macros oustide current module
Here is the situation.
I have a "personal.xls" that loads a custom toolbar and contains one of many frequently used macros. I have another workbook with 6 frequently used macros that is accessible publicly, department wide; we will call this workbook "Stuff.xls". I would like to call the macro "GL_Import" from the toolbar that "Personal.xls" loaded. I know that I can link the buttons directly to the macros in the "Stuff.xls" workbook. I could also copy the modules, forms, and such from the"Stuff.xls" to "personal.xls" and have them linked directly to the copy in my "personal.xls". What I want to do is link the custom toolbar button to a macro in "personal.xls" which opens "stuff.xls" then runs the "GL_Import". The answer is probably not nearly as difficult as I have made it. Thanks for you help in advance. Mic |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Macros oustide current module
Why is it you don't want to link directly to Stuff.xls. If you do, when the
button is pushed, Stuff.xls will be opened and the macro executed. I am not sure of the advantage of going through personal.xls to get Stuff.xls opened, unless you want Stuff.xls to be closed immediately after running the macro - but if it is marked read-only, having it open shouldn't cause a problem. -- Regards, Tom Ogilvy "Mic" wrote in message ... Here is the situation. I have a "personal.xls" that loads a custom toolbar and contains one of many frequently used macros. I have another workbook with 6 frequently used macros that is accessible publicly, department wide; we will call this workbook "Stuff.xls". I would like to call the macro "GL_Import" from the toolbar that "Personal.xls" loaded. I know that I can link the buttons directly to the macros in the "Stuff.xls" workbook. I could also copy the modules, forms, and such from the"Stuff.xls" to "personal.xls" and have them linked directly to the copy in my "personal.xls". What I want to do is link the custom toolbar button to a macro in "personal.xls" which opens "stuff.xls" then runs the "GL_Import". The answer is probably not nearly as difficult as I have made it. Thanks for you help in advance. Mic |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Macros oustide current module
Thank you.
As I said in my question, the answer was probably far easier than I was making it out to be. I thought I had tried to link to the "Stuff.xls" macro, apparently I had not tried that before I made a few futile attempts at writing some code to open the workbook and execute the macro. Again the KISS rule was overlooked. Thanks again. Mic -----Original Message----- Why is it you don't want to link directly to Stuff.xls. If you do, when the button is pushed, Stuff.xls will be opened and the macro executed. I am not sure of the advantage of going through personal.xls to get Stuff.xls opened, unless you want Stuff.xls to be closed immediately after running the macro - but if it is marked read-only, having it open shouldn't cause a problem. -- Regards, Tom Ogilvy "Mic" wrote in message ... Here is the situation. I have a "personal.xls" that loads a custom toolbar and contains one of many frequently used macros. I have another workbook with 6 frequently used macros that is accessible publicly, department wide; we will call this workbook "Stuff.xls". I would like to call the macro "GL_Import" from the toolbar that "Personal.xls" loaded. I know that I can link the buttons directly to the macros in the "Stuff.xls" workbook. I could also copy the modules, forms, and such from the"Stuff.xls" to "personal.xls" and have them linked directly to the copy in my "personal.xls". What I want to do is link the custom toolbar button to a macro in "personal.xls" which opens "stuff.xls" then runs the "GL_Import". The answer is probably not nearly as difficult as I have made it. Thanks for you help in advance. Mic . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALLING MACROS FROM A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
calling a module | Excel Discussion (Misc queries) | |||
How to add formula calling up current workbook when sheet copied | Excel Discussion (Misc queries) | |||
Calling macros from another XL Workbook | Excel Programming | |||
Close current Workbook after calling macro in other | Excel Programming |