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
|