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 - 06 Oct 2004 11:19 GMT
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
--
Nick
ross - 06 Oct 2004 15:31 GMT
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 - 06 Oct 2004 21:54 GMT
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.
> 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
[quoted text clipped - 3 lines]
> some more efficient solutions out there. I would appreciate any
> advice. Thanks

Signature
Dave Peterson
ec35720@msn.com