|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub del()
- Dim Present As Presentation
- Dim Sld As Slide, Shp As Shape
- Set Present = Application.ActivePresentation
- For Each Sld In Present.Slides
- For Each Shp In Sld.Shapes
- If Shp.Type = msoEmbeddedOLEObject Then
- Debug.Print Shp.Application.Name, Shp.Type
- Set objShapes = Sld.Shapes(Shp.Name).OLEFormat.Object
- objShapes.Worksheets("Sheet1").Cells(1, 1) = 90
- End If
- Next Shp
- Next Sld
-
- End Sub
复制代码
关键点是要搞清楚
objShapes.Worksheets("Sheet1").Cells(1, 1) = 90
如何定义ObjShapes是什么类型。
|
|