spill-the-beans
Board Regular
- Joined
- Feb 7, 2013
- Messages
- 52
Hi,
So I have a bit of vba code that I run on lots of different files. The file names are all dependent, so I have a1_s1, a1_s2, a1_s3; a2_s1_, a2_s2_, a2_s3 and so on.
What I'm doing at the moment is running the code with the file name a1_s1 in the sub, then doing find&replace, and replacing all mentions of "s1" with "s2", then running the code again... find and replace "s2" with "s3" and running the code.... and so on.
I was wondering if I could write another macro that would run the code, do the find and replace for me, run the code, do another find and replace, run the code... etc.
Does anyone know how I could achieve this?
So I have a bit of vba code that I run on lots of different files. The file names are all dependent, so I have a1_s1, a1_s2, a1_s3; a2_s1_, a2_s2_, a2_s3 and so on.
What I'm doing at the moment is running the code with the file name a1_s1 in the sub, then doing find&replace, and replacing all mentions of "s1" with "s2", then running the code again... find and replace "s2" with "s3" and running the code.... and so on.
I was wondering if I could write another macro that would run the code, do the find and replace for me, run the code, do another find and replace, run the code... etc.
Does anyone know how I could achieve this?
