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

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 :)

Is it possible to get data from several word files having static f
 

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" wrote:

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 :)

Is it possible to get data from several word files having static f
 

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)



On Jun 18, 4:23 pm, steve_doc
wrote:
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" wrote:
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 :)- Hide quoted text -

- Show quoted text -