Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding embedded object type in Excel Worksheet
-- HTH, Barb Reinhardt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding embedded object type in Excel Worksheet
Usually I use "For Each" if you know the type.
I think if it is a OLEboject the use for each obj in worksheets.oleobjects I usually find the object are shapes and use for each obj in worksheets.shapes I have a lot of problems with pictures because thsi method is the only waay of getting an inserted picture name. You can filter the types if necessary by using the name property for example for each pict in worksheets.shapes if instr(pict.name,"Picture") then 'enter your code here end next pict "Barb Reinhardt" wrote: -- HTH, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Programming | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel |