Hi,
I have a "master" workbook, where I write all my macros, and do all general changes.
My colleagues then copy this "master" and change different things, but only small things like names and other identifiers.
What I would like to know is, if it is possible to write a sub, that can find a specific sub, in each of my colleagues workbooks, and rewrite it.
Currently they have 47 versions of this workbook, with at least 4 sheets in each of them. This means that I have to update these workbooks 188 separate places each time I make a change to a sub. Hence it will save me an enormous amount of time if I could write a "Mass edit" sub that could rewrite the macros in all of my colleagues workbooks at once.
Is this possible? I'm really desperate for some help here
Thanks in advance!
Maagaard
I have a "master" workbook, where I write all my macros, and do all general changes.
My colleagues then copy this "master" and change different things, but only small things like names and other identifiers.
What I would like to know is, if it is possible to write a sub, that can find a specific sub, in each of my colleagues workbooks, and rewrite it.
Currently they have 47 versions of this workbook, with at least 4 sheets in each of them. This means that I have to update these workbooks 188 separate places each time I make a change to a sub. Hence it will save me an enormous amount of time if I could write a "Mass edit" sub that could rewrite the macros in all of my colleagues workbooks at once.
Is this possible? I'm really desperate for some help here
Thanks in advance!
Maagaard