Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Embedded Object Type in Worksheet
I have the following snippet of code:
With oWS If .OLEObjects.Count 0 Then For i = 1 To .OLEObjects.Count Debug.Print .OLEObjects(i).Name Next i End If End With I really want to know if the OLEObject is an Excel chart? How do I do that? Thanks, Barb Reinhardt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Embedded Object Type in Worksheet
MsgBox ActiveSheet.ChartObjects.Count
-- Jim "Barb Reinhardt" wrote in message ... |I have the following snippet of code: | | With oWS | If .OLEObjects.Count 0 Then | For i = 1 To .OLEObjects.Count | Debug.Print .OLEObjects(i).Name | | Next i | End If | End With | | I really want to know if the OLEObject is an Excel chart? How do I do that? | | Thanks, | Barb Reinhardt | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Embedded Object Type in Worksheet
Hello Barb
Why not use the ChartObjects method? For i = 1 To oWS.ChartObjects.Count MsgBox oWS.ChartObjects(i).Name Next i HTH Cordially Pascal "Barb Reinhardt" a écrit dans le message de news: ... I have the following snippet of code: With oWS If .OLEObjects.Count 0 Then For i = 1 To .OLEObjects.Count Debug.Print .OLEObjects(i).Name Next i End If End With I really want to know if the OLEObject is an Excel chart? How do I do that? Thanks, Barb Reinhardt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Embedded Object Type in Worksheet
I believe I've figured out what I need.
Thanks, Barb Reinhardt "papou" wrote: Hello Barb Why not use the ChartObjects method? For i = 1 To oWS.ChartObjects.Count MsgBox oWS.ChartObjects(i).Name Next i HTH Cordially Pascal "Barb Reinhardt" a écrit dans le message de news: ... I have the following snippet of code: With oWS If .OLEObjects.Count 0 Then For i = 1 To .OLEObjects.Count Debug.Print .OLEObjects(i).Name Next i End If End With I really want to know if the OLEObject is an Excel chart? How do I do that? Thanks, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding embedded object type in Excel Worksheet | Excel Programming | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Programming | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel |