Sub test()
With ActiveSheet
For i = 1 To .Pictures.Count
MsgBox .Pictures(i).Name
Next
End With
End Sub
non ici on parle de shapes et pictures (avec le "s" ) qui sont des collectionsLes fonctions Shape et Picture ne font pas la même chose.
Cells(i, 2) = ActiveSheet.Pictures(i).Name
Cells(i + 7, 2) = ActiveSheet.Shapes(i).Name
Cells(i, 2) = ActiveSheet.Pictures(i).Name
Cells(i + 7, 2) = ActiveSheet.Shapes(i).Name
Sub ChapiChapo()
Dim Shp As Shape, i&
[A1:D1] = [{"TypeName Shape", "Nom Shape", "AutoShapeType", "Type"}]
i = 2
For Each Shp In ActiveSheet.Shapes
Cells(i, 1).Resize(, 4) = Array(TypeName(Shp), Shp.Name, Shp.AutoShapeType, Shp.Type)
i = i + 1
Next
[A1].CurrentRegion.Columns.AutoFit
End Sub
Et il n'y a aucun bug dans ces collections. d'ailleurs lequel ?
Cells(i + 7, 2) = ActiveSheet.Shapes(i).Name
heu......................................................Shapes ne référence pas les Formes alors que Pictures les référence.
Sub liste()
' Liste les Pictures
nombre = ActiveSheet.Pictures.Count
For i = 1 To nombre
Cells(i , 2) = ActiveSheet.Pictures(i).Name
Next i
' Liste les Shapes
nombre = ActiveSheet.Shapes.Count
For i = 1 To nombre
Cells(i+ 7, 2) = ActiveSheet.Shapes(i).Name
Next i
End Sub
Sub liste()
' Liste les Pictures
nombre = ActiveSheet.Pictures.Count
For i = 1 To nombre
Cells(i + 7, 2) = ActiveSheet.Pictures(i).Name
Next i
' Liste les Shapes
nombre = ActiveSheet.Shapes.Count
For i = 1 To nombre
Cells(i, 2) = ActiveSheet.Shapes(i).Name
Next i
End Sub
Sub ChapiChapo()
Dim Shp As Shape, i&
[A1:D1] = [{"TypeName Shape", "Nom Shape", "AutoShapeType", "Type","index ordre"}]
'****************************************************
'methode Staple1600 fonctionne
'i = 2
'For Each Shp In ActiveSheet.Shapes
'Cells(i, 1).Resize(, 4) = Array(TypeName(Shp), Shp.Name, Shp.AutoShapeType, Shp.Type, Shp.Index)
'i = i + 1
'Next
'********************************************************
'*********************************************************
'cette mehode de boucle déclenche une erreur je ne sais pas pourquoi
For i = 1 To ActiveSheet.Shapes.Count
Cells(i + 1, 1).Resize(, 4) = Array(TypeName(Shapes(i)), Shapes(i).Name, Shapes(i).AutoShapeType, Shapes(i).Type, i)
Next
'**********************************************************
[A1].CurrentRegion.Columns.AutoFit
End Sub
Sub Test()
For Each Shp In ActiveSheet.Shapes
If Shp.Type = 13 Then
MsgBox Shp.Name
End If
Next
End Sub
oui l'inconvénient finalement est de devoir boucler sur des object différents pour chopper le seul qui a un type picturePour en revenir au post #1, ce code semble marcher. Il ne liste que les images.
VB:Sub Test() For Each Shp In ActiveSheet.Shapes If Shp.Type = 13 Then MsgBox Shp.Name End If Next End Sub
Sub ChapiChapo_II()
Dim shp As Shape, I&
[A1:E1] = [{"TypeName Shape", "Nom Shape", "AutoShapeType", "Type","NB"}]
With ActiveSheet
For I = 1 To .Shapes.Count
Cells(I + 1, 1).Resize(, 5) = Array(TypeName(.Shapes(I)), .Shapes(I).Name, .Shapes(I).AutoShapeType, .Shapes(I).Type, I)
Next
End With
[A1].CurrentRegion.Columns.AutoFit
End Sub
' Shyam Pillai, Brian Reilly & Steve Rindsberg
Sub Object_Types_on_This_Slide()
'Refers to each object on the current page and returns the Shapes.Type
'Can be very useful when searching through all objects on a page
Dim it As String
Dim i As Integer
Dim Ctr As Integer
'''''''''''''''''
'Read-only Long
'''''''''''''''''
For i = 1 To ActiveSheet.Shapes.Count 'ActiveWindow.Selection.SlideRange.Shapes.Count
'No need to select the object in order to use it
With ActiveSheet.Shapes(i) 'ActiveWindow.Selection.SlideRange.Shapes(i)
'But it is easier to watch when the object is selected
'This next line is for demonstration purposes only.
'It is not necessary
'ActiveWindow.Selection.SlideRange.Shapes(i).Select
ActiveSheet.Shapes(i).Select
Select Case .Type
'Type 1
Case msoAutoShape
it = "an AutoShape. Type : " & .Type
'Type 2
Case msoCallout
it = "a Callout. Type : " & .Type
'Type 3
Case msoChart
it = "a Chart. Type : " & .Type
'Type 4
Case msoComment
it = "a Comment. Type : " & .Type
'Type 5
Case msoFreeform
it = "a Freeform. Type : " & .Type
'Type 6
Case msoGroup
it = "a Group. Type : " & .Type
' If it's a group them iterate thru
' the items and list them
it = it & vbCrLf & "Comprised of..."
For Ctr = 1 To .GroupItems.Count
it = it & vbCrLf & _
.GroupItems(Ctr).Name & _
". Type:" & .GroupItems(Ctr).Type
Next Ctr
'Type 7
Case msoEmbeddedOLEObject
it = "an Embedded OLE Object. Type : " & .Type
'Type 8
Case msoFormControl
it = "a Form Control. Type : " & .Type
'Type 9
Case msoLine
it = "a Line. Type : " & .Type
'Type 10
Case msoLinkedOLEObject
it = "a Linked OLE Object. Type : " & .Type
With .LinkFormat
it = it & vbCrLf & "My Source: " & _
.SourceFullName
End With
'Type 11
Case msoLinkedPicture
it = "a Linked Picture. Type : " & .Type
With .LinkFormat
it = it & vbCrLf & "My Source: " & _
.SourceFullName
End With
'Type 12
Case msoOLEControlObject
it = "an OLE Control Object. Type : " & .Type
'Type 13
Case msoPicture
it = "a embedded picture. Type : " & .Type
'Type 14
Case msoPlaceholder
it = "a text placeholder (title or regular text--" & _
"not a standard textbox) object." & _
"Type : " & .Type
'Type 15
Case msoTextEffect
it = "a WordArt (Text Effect). Type : " & .Type
'Type 16
Case msoMedia
it = "a Media object .. sound, etc. Type : " & .Type
With .LinkFormat
it = it & vbCrLf & " My Source: " & _
.SourceFullName
End With
'Type 17
Case msoTextBox
it = "a Text Box."
'Type 18 = msoScriptAnchor, not defined in PPT pre-2000 so we use the numeric value
'Case msoScriptAnchor
Case 18
it = " a ScriptAnchor. Type : " & .Type
'Type 19 = msoTable, not defined in PPT pre-2000 so we use the numeric value
'Case msoTable
Case 19
it = " a Table. Type : " & .Type
'Type 19 = msoCanvas, not defined in PPT pre-2000 so we use the numeric value
'Case msoCanvas
Case 20
it = " a Canvas. Type : " & .Type
'Type 21 = msoDiagram, not defined in PPT pre-2000 so we use the numeric value
'Case msoDiagram
Case 22
it = " a Diagram. Type : " & .Type
'Type 22 = msoInk, not defined in PPT pre-2000 so we use the numeric value
'Case msoInk
Case 22
it = " an Ink shape. Type : " & .Type
'Type 23 = msoInkComment, not defined in PPT pre-2000 so we use the numeric value
'Case msoInkComment
Case 23
it = " an InkComment. Type : " & .Type
'Type -2
Case msoShapeTypeMixed
it = "a Mixed object (whatever that might be)." & _
"Type : " & .Type
'Just in case
Case Else
it = "a mystery!? An undocumented object type?" & _
" Haven't found one of these yet!"
End Select
MsgBox ("I'm " & it)
End With
Next i
End Sub