AddOLEObject

[Sean McPoland]

hi all,

I am trying to use the AddOLEObject function to add a
specific chart from an existing Excel sheet. The Chart is
on and individual page.

How do i get AddOLEObject to select a specified chart,
rather than the first one for display, or am I
misunderstanding AddOLEObject, as in AddOLEObject works on
the whole object rather than part of it?

Is there an easier way to do what i want (the AddOLEObject
needs to work in multiple Office programs so I want to use
the same process for word powerpoint etc.)

Using the Insert->Object method I know I can select a
range name - but this is not what I want.

Thanks in advance
regards
Sean