Export to Word - Update Chart Datasheet

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have a form that I am exporting data from into a Word Document.
I am comfortable with the export of variables etc to fields in word which
works fine.
I am trying to update a graph that I have in the Word document that shows
activity over a 24hr period and is a static chart

Can anyone tell me the syntax to update the Word graph Datasheet properties
in order the graph changes on creation of a new document ??

I am using the WordDoc.Documents(1).Variables to update fields but looking
for a similar mechanism to update the Word document graph datasheet
 
Please cancel all
obliged for those who looked - Have found the solution

With objDoc
.InlineShapes(1).OLEFormat.Activate
Set objChart = .InlineShapes(1).OLEFormat.Object
End With

With objChart
.Application.DataSheet.Range("A1").Value = 50
End With
 
Back
Top