How can I use Excel macros with ASP code?

[pdevteam]

Hi!

I'm developing an application with ASP, which should retrieve data from database to Microsoft Excel (2000).

This works fine, but the customer wants that the ASP script also produces basic-graph for him.

There comes always only two columns of data so I thought that will I be able to use the following Excel macro with the script:

-----
Range("A:A,B:B&quot.Select
Range("B1&quot.Activate
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Table1&quot.Range("A1:B7&quot, PlotBy:= _
xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="Taul1"
With ActiveChart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With
---

This works in Excel, but how can I embed it to ASP script.

If you have any suggestions or examples, I would be happy.

Thank you!