How do you find ClassTypes Info..?
 

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

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

How do you find ClassTypes Info..?
 

Thanx Peter will give it a Wizz..!
Andrew

"Peter T" <peter_t@discussions wrote in message
...
| 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
|
|
|
|