How do you create a chart in excel using vbscript?

[Smithsco]

I am editing an existing file by
dim appXL
set appXL = wscript.createobject("Excel.application&quot
appXL.visible = True
appXL.workbooks.open("d:\book3.xls&quot
appXL.activesheet.cells(2,2).value = "blah"
appXL.activeworkbook.save
appXL.quit

How can I make a bar chart (A1 to A12) using VBS?

 

[dougcranston]

Smithsco,

Some pages to check, with code include:

ASP and Excel Charts

http://www.serverwatch.com/tutorials/article.php/1493371

Excel and asp (charts)

http://www.swynk.com/friends/datema/myexcelchart.asp

For more, suggest you go to Google and try "vbscript excel charts" or "asp excel charts". Although these examples may wrap the VBScript in html, you can easily strip that off and work on it from there.

Hope this helps.
DougCranston