ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   AddOLEObject (https://www.excelbanter.com/excel-programming/309872-addoleobject.html)

Sean McPoland[_5_]

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


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com