| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you find ClassTypes..? | Excel Discussion (Misc queries) | |||
| What is VBA and where can I find more info on it? | Excel Worksheet Functions | |||
| Getting info from FIND/REPLACE | Excel Programming | |||
| How do you find info in a workbook? | Excel Discussion (Misc queries) | |||
| Help! Find info then copy and paste | Excel Programming | |||
![Andrew[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
