To elaborate, move the chart using copypicture/paste, and move the table by
copying an appropriately sized range and pasting, probably as html, although
I forget how Office 2000 used to do it (yes, there have been changes across
the versions).

I have some code you can try here:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:76EF2842-7DF0-4C7A-B145-139A07D83250@microsoft.com...
> Try to embed them as pictures. That way you can exactly control the
> material
> being copied/pasted.
>
> In Excel, while holding down the SHIFT key, pull-down:
>
> Edit > Copy picture..
>
> In Word (or PowerPoint) just paste
> --
> Gary's Student
>
>
> "Richard John" wrote:
>
>> I'm building an Office Application with Excel part of the application.
>> This
>> is all being done using Office 2000 Professional running under XP Pro
>> (SP2)
>>
>> 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
>> from
>> Excel, to bookmarked locations in Word. All works fine except that I have
>> these surplus table rows appended after each graph in Word, causing
>> unnecessary page breaks in Word, which then have 2B manually deleted.
>>
>> I have assigned each table and graph combination a range named in Excel.
>> The
>> range extends over the table and the graph completely. Does anyone know
>> of a
>> "clean" way to pluck out Excel tables and graphs for embedding into Word
>> without all those surplus table rows? eg. Is it possible to just plug the
>> graph into Word from Excel using VBA?
>>
>>
>> --
>>
>> Richard John
>> rjbpond@bigpond.net.au
>>
>>
>>