Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2011, 01:52 PM
Paul-NYS Paul-NYS is offline Word, Excel automation Windows XP Word, Excel automation Office 2007
Novice
Word, Excel automation
 
Join Date: Jun 2011
Posts: 11
Paul-NYS is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-28-2011, 06:27 PM
macropod's Avatar
macropod macropod is offline Word, Excel automation Windows 7 64bit Word, Excel automation Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 06-29-2011, 01:04 AM
OTPM OTPM is offline Word, Excel automation Windows 7 32bit Word, Excel automation Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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)
Reply With Quote
  #4  
Old 06-29-2011, 01:11 AM
Paul-NYS Paul-NYS is offline Word, Excel automation Windows XP Word, Excel automation Office 2007
Novice
Word, Excel automation
 
Join Date: Jun 2011
Posts: 11
Paul-NYS is on a distinguished road
Default 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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word, Excel automation 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
Word, Excel automation Excel to Word retrospect1984 Excel 1 02-18-2009 06:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft