Word 2007 embedded Chart with excel data saved within document.

[kaak]

I have a word 2007 document with a embedded chart.
The data for the chart is saved in a excel file within the document.
Is there a way to manipulate the excel data with vba.

 

[alborg]

Hi Kaak:

You can download a MS Word 2003 (2000 format) template with a chart
populated with a MS Access table here:
http://www.emrupdate.com/files/folders/al_borges/entry66564.aspx

It is discussed at length here: http://www.emrupdate.com/forums/t/9106.aspx

I originally derived it from a MS Excel code, so the only thing that you
have to change Do While... Loop event.

Cheers,
Al

 

[alborg]

Actually here's the URL of the Excel to Word version, from the Microsoft MVP
site:

http://word.mvps.org/FAQs/MacrosVBA/LinkTableWithGraph.htm

AL

 

[pilosite]

Actually here's the URL of the Excel toWordversion, from the Microsoft MVP
site:

http://word.mvps.org/FAQs/MacrosVBA/LinkTableWithGraph.htm

AL

this is an example for word 2003 (msGraph) not Office 2007.

I actually got the same question and problem:

I would like to update a chart embedded in Word programatically. I can
when I save the docx (xml chart), but I would like to do this with a
new document, unsaved.

Is there a simple way to edit chart data via macro ?