ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Software of scripting to grab data from MS word file and fill in Excel fields? (https://www.excelbanter.com/excel-programming/312610-software-scripting-grab-data-ms-word-file-fill-excel-fields.html)

Joe Blo

Software of scripting to grab data from MS word file and fill in Excel fields?
 
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

ross

Software of scripting to grab data from MS word file and fill in Excel fields?
 
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[_3_]

Software of scripting to grab data from MS word file and fill inExcel fields?
 
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.


Joe Blo wrote:

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


--

Dave Peterson



All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com