UMAKEMESIK
Active Member
- Joined
- Oct 3, 2005
- Messages
- 378
I have a folder full of the same doc. Same as in respect to the code in the background. The cover is different on each one as they pertain to each customer. I have about 300 different worksheets.
I have changed one element of the visual basic code that i need to change on each document.
I can go to each doc and open it up and change the code manually but was wondering if there was a way to write a scrip to run this.
It involves opening up VB editor, selecting a certain section of vb code and then pasting in the correct code, saving the doc , closing the doc and then do it again on the next one.
any ideas would be appreciated.
I have changed one element of the visual basic code that i need to change on each document.
I can go to each doc and open it up and change the code manually but was wondering if there was a way to write a scrip to run this.
It involves opening up VB editor, selecting a certain section of vb code and then pasting in the correct code, saving the doc , closing the doc and then do it again on the next one.
any ideas would be appreciated.
