#1
|
|||
|
|||
Word, Excel automation
Hi I have a Word document and an Excel document for each of 21 counties in our state. The Word document contains language, data, and charts with the data, charts coming from the corresponding Excel file. I am looking for a way to create 1 Word for all 21 counties where the Word document pulls data, charts to display in it from the correct county spreadsheet triggered by some kind of merge field, etc. in the Word document representing the county? Also, the data in the Excel file is not in 1 neat table. There are several groupings of data in the file that drive the charts and data from the document. Any ideas at all? Paul |
#2
|
||||
|
||||
Hi Paul,
A mailmerge can only use one source file - and the data all need to have the same arrangement. That seems to rule out that approach for what you've described. Any other form of automation would also require a consistent data layout. Beyond that, you can copy & paste from Excel to Word, using the 'paste link' option to link the document to the Excel workbook. that way, any changes in the workbook will update the document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul
You may want to consider embedding your Excel charts in your Word document. You can then edit/update/change them inside MS Woprd by simply clicking on the chart and Excel will open with the document. Once you have finished updating the chart in excel simply click outside of the chart to close the excel editor. The only downside to this may be the eventual size of the file depending on how much data is in each of the 21 charts. However it is worth considering this approach. Good luck. Tony(OTPM) |
#4
|
|||
|
|||
Word, Excel automation
Yeah, the mail merge will not work because the all data is not neatly organized in 1 table. I can embed the Excel charts in the Word documents, but was really looking for something to automate.
I was thinking of using the vlookup function, but this also seems to require 1 neat table. Anyone have experience with either this or a similar approach in this situation? Paul |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgent help regarding automation. | aligahk06 | Excel | 1 | 01-14-2010 01:55 PM |
Table of contents automation through VB 6.0 | Developer | Word | 0 | 06-09-2009 06:30 AM |
What is Application Automation and How can I use it in VBA | KramerJ | Excel | 0 | 03-30-2009 12:59 PM |
COM Automation Errors | ivanm | Word | 0 | 03-23-2009 07:02 PM |
Excel to Word | retrospect1984 | Excel | 1 | 02-18-2009 06:41 AM |