>That is how far I can get with Excel 97. What is the format of Chartwizard command?
>Thanks,
> Tanya.
>
>xl=CreateObject("Excel.Sheet")
>
>xl.Application.Visible=.T.
>
>*** Copy data to an excel spreadsheet
>for i = 1 to _TALLY
> xl.Application.Cells(i,1).Value = cust_distrib(i,1)
> xl.Application.Cells(i,2).Value = cust_distrib(i,2)
>endfor
>
>*** Add a ChartObject to the worksheet:
>ch1 = xl.Application.Worksheets("sheet1").ChartObjects.Add(100, 30, 400, 250)
>
>????????
I'm sorry. I've never moved so deep in Excel, moreover I have Excel95 only, so cannot give you much help on this topic. I just guess that Excel help should contain syntax,code example,etc.
Edward Pikman
Independent Consultant