Global Macros

[rthom]

Hi everyone.
I was wondering if it is possible to create and save a macro so that it can be accessed by all excel documents?
For example, I have a folder that contains hundreds of excel files. Every file needs to run this macro. So I guess i'm asking for the easiest way to insert the macro into each excel file and how to do this? Or if its even possible?

Thanks.
Ray

 

[Norie]

Ray

Do you really need the code in all the files?

Couldn't you just open each file run the code on the file, close the file?

If that's not suitable I suggest you search on personal.xls on the board.

Or perhaps an add-in?

Really depends what the code actually does.