Hello,

I have a set of workbooks that all have a similar macro in them. Each of
these macros contains a string I need to change, but to change it manually
in each file is time prohibitive - 60+ files.

Given I already have one of these files open with a seperate macro, from the
seperate macro, how do I access the module - say Module1, search for the
line that contains the text needing to be changed, change it and then close
the file?

I already have the list of files and the loop to go through all of them. I
am just unclear on how to change the Module1/Macro text from another macro.

Any ideas?

Thank you very much in advance.

Eric Pearce