Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically linking data from Word into Excel
I am running Office 2007 Professional on Vista Business.
I do not need to maintain backwards compatibility with Office 97-2003 (doc,xls, etc.), but it would be nice if I could. I am looking for a way to link data residing in Word documents into an Excel spreadsheet, so that it updates automatically. The situation: We have numerous Word (doc) files that get updated by users regularly (it is procedures for some of our business activities, so it pretty much has to stay in Word). (NOTE: The word documents themselves are stable in number for the most part, but content changes within it.) Included in these files are specific items (Management Points) that need to get pulled out and linked on a spreadsheet (xls). All the users have been trained to use the styles and formatting sheet to identify the various classes of data, so it is formatted consistently in the Word document as a Style titled Management Point. The problem: Several times a week, the Management Points need to be updated in a spreadsheet (Primary Review) that is where management records its reviews, changes, etc. of the items. As a business control, the users of the word documents can't update the Primary Review spreadsheet, even to drop in the items Management Points. There are numerous (100) of these Management Points in each document, and while only a few generally change per document each time, the change needs to be captured on the spreadsheets. Right now, the spreadsheets and documents are in the same directory, but it would be useful if they could be separated -- but not at all critical. The current solution is that somebody opens all the word documents, selects for all the content formatted as a Management Point, copies it, and drops it manually into the Primary Review spreadsheet. The process itself works fine, but it requires somebody actually doing it, which doesn't always happen. What I am hoping is that there is a function where I can link from word document data to the Primary Review spreadsheet. I do this all the time between spreadsheet, but I come up short when trying to link to anything in a Word document. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically linking data from Word into Excel
Why not embed an Excel workbook object in the Word documents in question.
This would be a dynamic update and eliminate the need for any manaul updating. All you would have to do in the Word document is double click on the Excel object to activate the Excel application. Hope this helps. -- Kevin Backmann "Jay in MD" wrote: I am running Office 2007 Professional on Vista Business. I do not need to maintain backwards compatibility with Office 97-2003 (doc,xls, etc.), but it would be nice if I could. I am looking for a way to link data residing in Word documents into an Excel spreadsheet, so that it updates automatically. The situation: We have numerous Word (doc) files that get updated by users regularly (it is procedures for some of our business activities, so it pretty much has to stay in Word). (NOTE: The word documents themselves are stable in number for the most part, but content changes within it.) Included in these files are specific items (Management Points) that need to get pulled out and linked on a spreadsheet (xls). All the users have been trained to use the styles and formatting sheet to identify the various classes of data, so it is formatted consistently in the Word document as a Style titled Management Point. The problem: Several times a week, the Management Points need to be updated in a spreadsheet (Primary Review) that is where management records its reviews, changes, etc. of the items. As a business control, the users of the word documents can't update the Primary Review spreadsheet, even to drop in the items Management Points. There are numerous (100) of these Management Points in each document, and while only a few generally change per document each time, the change needs to be captured on the spreadsheets. Right now, the spreadsheets and documents are in the same directory, but it would be useful if they could be separated -- but not at all critical. The current solution is that somebody opens all the word documents, selects for all the content formatted as a Management Point, copies it, and drops it manually into the Primary Review spreadsheet. The process itself works fine, but it requires somebody actually doing it, which doesn't always happen. What I am hoping is that there is a function where I can link from word document data to the Primary Review spreadsheet. I do this all the time between spreadsheet, but I come up short when trying to link to anything in a Word document. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically linking data from Word into Excel
I don't know much about 2007 (still using 2003 and loving it). Anyway, this
may be a good resource for you. http://word.mvps.org/ http://word.mvps.org/faqs/interdev/c...xlfromword.htm http://word.mvps.org/FAQs/InterDev/C...WordFromXL.htm Regards, Ryan--- -- RyGuy "Jay in MD" wrote: I am running Office 2007 Professional on Vista Business. I do not need to maintain backwards compatibility with Office 97-2003 (doc,xls, etc.), but it would be nice if I could. I am looking for a way to link data residing in Word documents into an Excel spreadsheet, so that it updates automatically. The situation: We have numerous Word (doc) files that get updated by users regularly (it is procedures for some of our business activities, so it pretty much has to stay in Word). (NOTE: The word documents themselves are stable in number for the most part, but content changes within it.) Included in these files are specific items (Management Points) that need to get pulled out and linked on a spreadsheet (xls). All the users have been trained to use the styles and formatting sheet to identify the various classes of data, so it is formatted consistently in the Word document as a Style titled Management Point. The problem: Several times a week, the Management Points need to be updated in a spreadsheet (Primary Review) that is where management records its reviews, changes, etc. of the items. As a business control, the users of the word documents can't update the Primary Review spreadsheet, even to drop in the items Management Points. There are numerous (100) of these Management Points in each document, and while only a few generally change per document each time, the change needs to be captured on the spreadsheets. Right now, the spreadsheets and documents are in the same directory, but it would be useful if they could be separated -- but not at all critical. The current solution is that somebody opens all the word documents, selects for all the content formatted as a Management Point, copies it, and drops it manually into the Primary Review spreadsheet. The process itself works fine, but it requires somebody actually doing it, which doesn't always happen. What I am hoping is that there is a function where I can link from word document data to the Primary Review spreadsheet. I do this all the time between spreadsheet, but I come up short when trying to link to anything in a Word document. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Excel data to Word table | Excel Discussion (Misc queries) | |||
Automatically Transfering Data from Excel to Word file | Excel Discussion (Misc queries) | |||
Linking excel data to a word document | Excel Discussion (Misc queries) | |||
data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions | |||
How to transfer info automatically from an excel data base to a word document OR an excel | Excel Programming |