OLEFormat（未知成员）：PowerPoint 中的无效请求

Question

我正在使用 Belisarius 的这个特定代码：

Sub a()

Dim oSl As PowerPoint.Slide
Dim oSh As PowerPoint.Shape

Set oSl = ActivePresentation.Slides(1)

Set oSh = oSl.Shapes(1)

With oSh.OLEFormat.Object.WorkSheets(1)
    .Range("A1").Value = .Range("A1").Value + 1
    .Range("A2").Value = .Range("A2").Value - 1
End With

Set oSl = Nothing
Set oSh = Nothing

End Sub  

我使用 PowerPoint 2010 中的插入菜单嵌入了折线图（能够更改 excel 中的值）。我收到一条错误消息，提示 OLEFormat（未知成员）：无效请求。我知道这对某人有用，但显然我插入的不是一个对象。为什么我会收到此错误？

Answer 1

访问底层 Excel 工作表有点棘手 - 请尝试这种方法

  Sub Test()
Dim myChart As Chart
Dim myChartData As ChartData
Dim myWorkBook As Object
Dim myWorkSheet As Object

Set myChart = ActivePresentation.Slides(1).Shapes(1).Chart
Set myChartData = myChart.ChartData

myChartData.Activate

Set myWorkBook = myChartData.Workbook
Set myWorkSheet = myWorkBook.Worksheets(1)

With myWorkSheet
    .Range("A1").Value = .Range("A1").Value + 1
    .Range("A2").Value = .Range("A2").Value - 1
End With
myWorkBook.Close
Set myWorkBook = Nothing
End Sub