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

 

[Joseph Meehan]

I have embedded several Excel tables (fed from MS Access) and
associated graphs in a Word

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.

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.

 

[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

 

[Joseph Meehan]

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.

Sorry my message may have come across less friendly than I intended.
Since Access starts with an "A" we are the first on on the list and we get a
lot of unrelated questions and most don't know how to find a good group for
their question. You got my stock response.

However since the question is really about the Excel - Word link I would
suggest that an Excel group would be the best choice followed by a Word
group. It appears you have the Access - Excel link working.

Good Luck