I am a complete novice here... so any help suggested is really appreciated
I have a managed to write a macro to loop over directory and extract table value and save to new filename which is tablevalue.doc
Now I would like to do the following but I am struggling...
I have a directory of word files with 99 files named company1.doc --- company99.doc - this is my current directory
I want to loop over the each file in the current directory
open the first word document say company1.doc
extract the value of Table 2, cell 1 and row 2 --- this value will be either low/medium/high - this will then be the name of the word document I want to append to my current word document company1.doc
In this case in company1.doc the value in Table 2, cell1, row 2 is low
So now I want to go to another directory (this is path is always c:\deanj\) and contains the filenames low.doc/medium.doc/high.doc
I want to get the contents of c:\deanj\low.doc
I now want to append the contents of low.doc into my active word document company1.doc
save the concatenated word document into company1.doc
then go back through the loop
I would like to keep the formatting from both files.
Any help quickly will be greatly appreciated
Thanks
DeanJ
Bookmarks