Is it possible to get data from several word files having static format to one excel worksheet.

[Smits]

Greetings,

Is it possible to get data from several word files having static
format to one excel worksheet?

Say a folder consists several word files with a static format & has
details in it as

Word File - 1.doc Word File - 2.doc

Name of Student: ABC Name of Studen: PQR

Age: 18 Age: 25

Passing Percentage: 80% Passing Percentage: 68%


Details collated in one excel sheet: Data.xls
A B C
1 Name Age Passing Percentage
2 ABC 18 80
3 PQR 25 68

Pls help...

Will post some more details on trial done for this kind of
automation....Thanks

 

[steve_doc]

Definitely possible using either word or txt documents.

Is the data stored in the word docs always the same and in the same format?
Dependant on how many data sources you will have this could be a lengthy
procedure even for automation

 

[Smits]

Thanks for reply

Data is stored in word files & not in notepad/text files.

Word file has specific format. When I say specific, I mean >>

Specific e.g.(1)
Label -> Name of Student (It's on line 4 of word file) (Label would
not change to just 'Student')

Specific e.g.(2)
Label -> Name of Student (It could appear on line 5 of word file)