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
|