How do you find ClassTypes Info..?

A

Andrew

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
 
P

Peter T

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
 
A

Andrew

Thanx Peter will give it a Wizz..!
Andrew

| 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
|
| | > 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
| >
| >
|
|
 
Top