I have a group of excel files (about 50). Each of these excel files has a set
of 3 similar macros. Instead of opening each file and running the macros for
individual files, is there a way of automating or creating a master
file, that opens each file, calls its marcos, stores the results of the
macros
in the respective file, saves it before closing and then proceeds to call the
next file. Is there any simple way of doing this without changing the macros
in the individual files largely.

Secondly, is there a way i can write a routine such that if i were to make
changes to the macros in a file, it can be copied to all the other files,
after removing/replacing the older version of the same macro in the other
files.


any suggestions on these two questions will be of great help.

Thanks