Sub CopyFeuilleValeursSeules_vIV()
Dim sPth$, nFic$, fCopy As Worksheet, shp As Shape
sPth = "C:\temp\": nFic = "fValSeulesY.xlsx" ' adapter le chemin et le nom du fichier
Sheets("Feuil1").Copy ' adapter le nom de la feuille
Set fCopy = ActiveSheet
With fCopy.UsedRange
.Value = .Value
End With
On Error Resume Next
For Each shp In fCopy.Shapes
'supprime les shapes mais ni les images, ni les controles Active X
If Not shp.Type = 12 And Not shp.Type = 13 Then shp.Delete
Next
With Workbooks(fCopy.Parent.Name)
.SaveAs sPth & nFic, 51
.Close True
End With
End Sub