View Single Post
 
Old 08-24-2015, 04:26 PM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote