Automatically Update Linked Chart in MS Word

[JSearcy]

I have gotten great responses here in the past, so I hope someone out there happens to know the answer to this one...
My boss called me yesterday wanting to know if you could publish an Excel chart to the web (of course) - however, she wants it to automatically update whenever the source chart changes... Would be simple, except that in order to edit/update the web page, you must open it in edit mode(not desirable). I know you can command other applications from within Excel and was looking at making Excel launch the MS Word document containing the linked chart and update it in the BeforeClose()event of the workbook (Thus updating the webpage)... But I cannot find the original coding to command other applications...
ANY HELP WOULD BE MOST APPRECIATED

 

[Steve Hartman]

Why not just export the graph as a gif file to the web diretory?

 

[NateO]

Howdy J,

Steve may be onto something. Play with his.

In terms of working with Word in general, here's one of several samples on this board to work with Word:

http://www.mrexcel.com/board/viewtopic.php?topic=9180&forum=2&start=0

The link on 2nd page has some interesting code as well (the french one (.fr), the MS one required coffee to go through )

 

[Steve Hartman]

On 2002-07-06 18:26, NateO wrote:

Steve may be onto something. Play with his.

Thank you....and no thank you

I'll post some code on this Monday when I get back to the office.

 

[Steve Hartman]

The following code selects the graph named Chart 8 and exports and names it as a GIF file to the selected directory:

ActiveSheet.ChartObjects("Chart 8").Activate
Application.ActiveChart.Export Filename:="M:tscamtaistaisppmelAvailability1.gif", FilterName:="GIF"

An easy way to find the chart name is to right click it and select assign macro. The chart name will be displayed in the top line.

As a side note, the method for exporting a graph, described in the help file for both Excel 97 & 2000, doesn't work.
This message was edited by Steve Hartman on 2002-07-08 06:05

 

[JSearcy]

Thanks to everyone for the responses to my question. I figured out a solution myself... but I will keep your responses in my ever-growing VBA library, as I am sure that it will prove useful sooner or later.

Thanks!
This message was edited by JSearcy on 2002-07-09 10:48

 

[mak88]

Hello there,

The only thing you need to do is to make a chart in excel, copy the chart, when pasting in word say paste with source formatting and link data. And then go to File > Links and click the file link, below you'll see option to update manually or automatically. Check the box next to "automatic", and there you go. Problem solved !