How to write a macro to fix another macro
 

I just noticed there is a problem with one macro I wrote that has been
put into more than 70 similar but different files.

Instead of going into each file to edit the macro, is there a way to
create a macro and go into each file to fix that problemlic macro?


I can loop through a list to repeat same actions for these 70 or so
files, but couldn't figure out a way to use macro to change another
macro.


Help please. Thanks.

How to write a macro to fix another macro
 

Try taking a look here ...

http://www.cpearson.com/excel/vbe.htm

HTH.

"whatever" wrote:

I just noticed there is a problem with one macro I wrote that has been
put into more than 70 similar but different files.

Instead of going into each file to edit the macro, is there a way to
create a macro and go into each file to fix that problemlic macro?


I can loop through a list to repeat same actions for these 70 or so
files, but couldn't figure out a way to use macro to change another
macro.


Help please. Thanks.