It is possible to do but you would need to write a macro that opens each file, finds the relevant information and copies it to your excel sheet.
This is not a trivial exercise but if your 100 documents are very consistent it is certainly possible.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|