How can I update the data for a chart graph in word document from Access using VBA?

[cys052571]

Hi,

Is it possible to update the data for a chart graph in a word document from Access using VBA?

Thanks

 

[Rx_]

I am not that current on Word objects.
Just posted in the Samples DB some VBA Code for Excel that creates an Excel Chart then takes the chart to embed it into Power Point.
The code can be modified to run from Access.
It might sound a little round-about, but I just have more luck and control over Excel objects including charts.

 

[spikepl]

One of my clients has a setup with many charts. Charts are a bit of a pain in Access, as opposed to Excel. What we do is this:

A table in Excel is linked to a query in Access. A chart is based on that table. This Chart is linked to from Word. When data updates in Access, the chart in Excel and hence in Word will reflect the updated data. All this is achieved without one byte of code!

 

[Rx_]

That is a great solution I have used too.
Another question is: Embedded or Linked?
Either one can be the correct answer depending on the requirements.

 

[cys052571]

Thanks for the reply, Spikepl & Rx!

I will try the Spikepl's solution.