Hi,
I am developing a web based application. I need to export
a chart from Excel and display it on the Web as a picture.
Does anyone have the code to save an Excel graph as a
picture?

Alternatively, can I develop a template in Excel that has
buttons, drop down boxes and the chart and then save this
Excel template as a HTML file. How do I attach ASP code
to these buttons or drop downs?

Your help is greatly appreciated!
Thanks in advance

Hi Rosh,

If you want to develop a dynamic web application with asp technology,
you're supposed to have an Internet Information Server.

First, you must have Excel installed on the server. Then you have to
develop a component (dll) with Visual Basic or C++, which opens an
instance of Excel on demand and creates the graphic and exports. This
component will be called later in the asp page with the parameters
you're passing.

By the way exporting a chart is the easiest thing on that.
If you have created the chart:
ActiveChart.Export Filename:="xxx.gif", Filtername="gif"

You can not write asp code for the form objects on an excel sheet.


---
Message posted from http://www.ExcelForum.com/