A
andibevan
Hi All,
I have 82 MS word files in the same directory which all contain a tabl
and I need to extract a piece of information from each file.
The information I require from each word document is next to the ro
headings "Primary Effect" and "Secondary Effect" i.e.:-
Column 1 Coumn 2
Primary Effect INFORMATION to EXTRACT 1
Secondary Effect INFORMATION to EXTRACT 2
I think I essentially need something that will cycle through each fil
in the directory, open it, find the information in the cell next t
"Primary Effect" and "Secondary Effect" and copy it into th
spreadsheet against the file name.
Any help with this would be greatfully received.
Thanks
Andy
:confused
I have 82 MS word files in the same directory which all contain a tabl
and I need to extract a piece of information from each file.
The information I require from each word document is next to the ro
headings "Primary Effect" and "Secondary Effect" i.e.:-
Column 1 Coumn 2
Primary Effect INFORMATION to EXTRACT 1
Secondary Effect INFORMATION to EXTRACT 2
I think I essentially need something that will cycle through each fil
in the directory, open it, find the information in the cell next t
"Primary Effect" and "Secondary Effect" and copy it into th
spreadsheet against the file name.
Any help with this would be greatfully received.
Thanks
Andy
:confused