In excel I am trying to delete shapes within a range. Shapes can be pictures, ole objects etc.
I have got the range successfully selected. Now the problem is I cannot succeed in getting to these shapes within that selection.
I have tried
$oExcel = _Excel_Open()
; derive NewRange
.
.
.
$NewRange.Select ; now select that range
; now try to get to the shape selection within that range and delete all the shapes
$ShapeRange = $oExcel.Selection.Shapes.SelectAll
$ShapeRange.delete
The problem seems to the shapes is not a valid reference after selection.
Desperate for help.