Thread: AddOLEObject
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean McPoland[_5_] Sean McPoland[_5_] is offline
external usenet poster
 
Posts: 1
Default AddOLEObject

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