For Lothar Haensler

[regis]

I Lothar

thanks a lot for your help and sorry for this public call but I not able to send private message.

I don't have exemple code because am not able to access at the object "Microsoft Excel Chart" I put graph in my form an I change data in sheet1 manuel but I will like to change data in sheet1 by code.

Chart1. ???? I don't know what can I use.

I have DBGrid with data an I would like to make graph with this data but I don't know what can I do.

Is verry important I use Excel graph because I need a standard deviation.

Thanks a lot

if you need more info please give me your Email.

Redg

[email protected]

[Lothar Haensler]

OK, here is a sample that transfers data from VB to Excel (2000!) via automation:

private Sub Command1_Click()
Dim x as new Excel.Application
Dim wb as Excel.Workbook
x.Visible = true
set wb = x.Workbooks.Add
Dim ws as Worksheet

set ws = wb.Worksheets.Add
ws.Cells(1, 1) = 5
ws.Cells(2, 1) = 10
ws.Cells(3, 1) = 15
ws.Cells.Range("A1", "A3").Select

Dim sheet as Chart
set sheet = wb.Charts.Add

End Sub



it may not solve your problem but hopefully it gets you started.