Software of scripting to grab data from MS word file and fill in Excel fields?

[Joe Blo]

I have a 90 page financial report from MS word that I get each month.
I would like to find a software package or scripting tool that will
allow me to automate the process of grabbing #s from the ms word file
and filling in fields in an excel file. I have a feel that there may
be quite of programming involved in doing this. But perhaps there are
some more efficient solutions out there. I would appreciate any
advice. Thanks

 

[Nicky]

Hi,

Do the numbers appear in the same part of the word document each tim
(eg always in the same row/column of the same table). If so, copyin
the data into excel should be fairly simple.

If the document is updated regularly, the relevant numbers might be i
fields or links, in which case they'd also be easy to copy.

If they always follow the same form of words, then it may be possibl
(eg last month's sales were $##,###).

Otherwise, it will be difficult to identify which numbers to cop
where

 

[ross]

I think you will need to get a excel/office consultant to write such a
thing 'cus it will depend on how you data is set out and lots of
things that are speifc to your siutation. If you have a newer version
of office, you might like to try saving the file as XML, and then
opening it in word. - it may take you part of the way there.

Good luck

 

[Dave Peterson]

I've seen lots of people ask how to use Excel as a database to populate a word
document (mailmerge from within MSWord). But I haven't seen your question much
(if ever).

You may want to post in the MSWord newsgroup if you don't get a real good
solution here.