Embed Excel graphs in Word

[Richard John]

I have embedded several Excel tables (fed from MS Access) 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

 

[Lynn Trapp]

Richard,
I think the experts that frequent the Word newsgroups will be of much more
help to you than we are. Some of us have a hard time even typing in
Word...<g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Richard John]

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

Nobody misdirected me here. This was an Office automation question related
to Access, Excel and Word working together. I presumed someone in the
Access NG may have a answer.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

I did say Office 2000 pro. I ommitted XP Pro

RJ