View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default How do you find ClassTypes Info..?

Search "OLE Programmatic Identifiers" in VBA help

include the classtype in quotes
ClassType:="Forms.Image.1"

Simply remember "Forms.control-name.1"

to return it -

MsgBox ActiveSheet.OLEObjects(1).progID

Regards,
Peter T

"Andrew" wrote in message
...
Trying to do..

With ActiveSheet.OLEObjects.Add(ClassType:=Forms.Image etc...
.Name="TmpImage"

Then
ActiveSheet.OLEObjects(TmpImage).Delete

Want to Investigate Further Other Available
ClassTypes (Sounds/Video Etc..)
What is the best way to find the ClassTypes Available
and properties etc for the Class...?

Thanx for any Info
Andrew