Embed Excel Graphs in Word

[Richard John]

I have embedded several Excel tables and associated graphs in a Word
document. I have done this using VBA, sucking in the tables and graphs to
bookmarked locations in Word. All works fine except that I have these
surplus table rows appended after each graph, causing unnecessary page
breaks in Word, which then have 2B manually deleted. Each table and graph
combination is assigned a named range in Excel. The range has been extended
to cover the table and the graph completely.

Does anyone know of a "clean" way to embed Excel tables and graphs into Word
without all those surplus table rows? eg. Is it possible to just plug the
graph into Word from Excel using VBA?

This is all being done using Office 2000 Pro.

===========

A related question: I can't work out how to get an embedded graph in Word to
automatically update when the underlying data changes. The idea here is to
update just the table data from MS Access directly and let the graph look
after itself. I have some trouble with MS Graph in Word. This is why I have
used a roundabout way to achieve this:

Access ==> Excel (for the graphs) ===>Word

Maybe clunky, but it has provided a solution ... but I want a better one ...


============


Thanks

 

[Cindy M -WordMVP-]

Hi Richard

I have embedded several Excel tables and associated graphs in a Word
document. I have done this using VBA, sucking in the tables and graphs to
bookmarked locations in Word. All works fine except that I have these
surplus table rows appended after each graph, causing unnecessary page
breaks in Word, which then have 2B manually deleted. Each table and graph
combination is assigned a named range in Excel. The range has been extended
to cover the table and the graph completely.

Does anyone know of a "clean" way to embed Excel tables and graphs into Word
without all those surplus table rows? eg. Is it possible to just plug the
graph into Word from Excel using VBA?

This is all being done using Office 2000 Pro.

Probably/possibly. I need a bit more information...

You don't show us the code, nor describe how the code is
bringing these Excel
things. At first, I assumed they're coming in as OLE
objects, but then reading
that the extra rows need to be "deleted manually" makes me
unsure what you
really have, and how you're going about doing this?

From your last paragraph: you really want/need just the
graph, not the data
table? As a static object, or does it need to link back to
the original data?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail