Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe Blo - 06 Oct 2004 03:34 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.