Export Chart from Excel to GIF

[GabKPK]

Hi,
I need to create a web page which will show some updated excel charts. The excel files are assumed to be stored at the web server. What should I do? I have no experience in doing this. Is that possible to have some scripts in the HTML to run macros in the excel files? Then inside the macro of the excel files, it will export the chart object to a GIF picture and replace the old picture file. Please help. Thanks.

 

[vbMax]

This may be part of the answer that you are looking for.
The following code can be placed in the Workbook_Open()
subroutine to automatically export a chart to a .gif
file, every time the workbook is opened.

ActiveSheet.ChartObjects("Chart 1&quot.Select
ActiveChart.Export Filename:="c:\whatever.gif", _
filtername:="GIF"

I hope this helps.

- vbMax

 

[GabKPK]

Thanks a lot for the codes, vbMax. So, anyone knows how to write script( say ASP) to run a macro in an excel?