"Master (Callable) Macro File"

moex201 · Mar 4th, 2002, 12:01 PM

Is there anyway to use a macro from another spreadsheet in the current open spreadsheet?
I have about 9 files using pretty much the same functions, and when I want to update any of the functions I have to update all of the macros on 9 files to keep them in sync.
I think if I put all of the macro functions in one callable macro xls file, I can just set my other macros to call that file so I can update in one place.

Any Ideas anyone?

gplhl · Mar 4th, 2002, 12:08 PM

Stick the Macro in your personal file

Personal.xls

moex201 · Mar 4th, 2002, 04:26 PM

Not sure what you mean. First of all I never used a "personal file" . But lets say I had a personal.xls. Where would I store it? Second , these excel files are on a server, so I have different people accessing them, so would I have to put my "personal.xls" file on the server?
And third, how would I call the functions from it's macro?

_________________
Give a carpenter a tool and he'll build a house, give a scientist a lab and he'll make a cure, give me a computer and I'll build you your application...

[ This Message was edited by: moex201 on 2002-03-06 07:53 ]

Mar 4th, 2002, 12:08 PM	#2
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	Stick the Macro in your personal file Personal.xls __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 12:01 PM	#1
moex201 New Member Join Date: Mar 2002 Posts: 6	Is there anyway to use a macro from another spreadsheet in the current open spreadsheet? I have about 9 files using pretty much the same functions, and when I want to update any of the functions I have to update all of the macros on 9 files to keep them in sync. I think if I put all of the macro functions in one callable macro xls file, I can just set my other macros to call that file so I can update in one place. Any Ideas anyone?

Mar 4th, 2002, 04:26 PM	#3
moex201 New Member Join Date: Mar 2002 Posts: 6	Not sure what you mean. First of all I never used a "personal file" . But lets say I had a personal.xls. Where would I store it? Second , these excel files are on a server, so I have different people accessing them, so would I have to put my "personal.xls" file on the server? And third, how would I call the functions from it's macro? _________________ Give a carpenter a tool and he'll build a house, give a scientist a lab and he'll make a cure, give me a computer and I'll build you your application... [ This Message was edited by: moex201 on 2002-03-06 07:53 ]