ChartData.Workbook property (PowerPoint)
Returns the workbook that contains the chart data associated with the chart. Read-only Object.
Syntax
expression.Workbook
expression A variable that represents a 'ChartData' object.
Remarks
Note
You must call the Activate method before referencing this property; otherwise, an error occurs.
Example
Note
Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.
The following example activates the Microsoft Excel workbook associated with the first chart in the active document. If the Excel workbook has multiple windows, the example activates the first window. The example then copies the contents of cells B1 through B5 and pastes the cell contents into the chart.
Note
Excel must be open to modify data in the workbook.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.ChartData.Activate
.Chart.ChartData.Workbook. _
Worksheets("Sheet1").Range("B1:B5").Copy
.Chart.Paste
End If
End With
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.