View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
whatever[_2_] whatever[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.