View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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