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

S

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

Guest

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
 
S

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top