Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Take part data from two fields and auto fill into 3rd field | Excel Worksheet Functions | |||
Storing Data in Excel, using Excel to fill out pre-made Word docum | Excel Discussion (Misc queries) | |||
How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
Fix too few data fields error message when merging excel and word | Excel Discussion (Misc queries) | |||
Any way to grab a .csv file from a folder using Wildcards | Excel Programming |