Embed Excel graphs in Word

  • Thread starter Thread starter Richard John
  • Start date Start date
R

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
 
Richard said:
I have embedded several Excel tables (fed from MS Access) and
associated graphs in a Word
Click to expand...

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.
 
Joseph Meehan said:
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.
Click to expand...

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.
Click to expand...

Thanks said:
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.
Click to expand...

I did say Office 2000 pro. I ommitted XP Pro

RJ
 
Richard said:
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.
Click to expand...

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
 
Back
Top