write exel

[davyquyo]

does somebody know how to write data to diffrent cells in an exel file


i can write in cell a1 but not in other cells


can someone help me

[Pasvorto]

xlSheet.Cells(X, y).Value = new value

X = row
y = cell

xlBook.Close savechanges:=True

[davyquyo]

i have googled a bit and i found this

Private Sub Form_Load()
Dim xl As Object
Dim wrk As Object
Dim sht As Object
Set xl = CreateObject("Excel.Application")
Set wrk = xl.Workbooks.Add()
Set sht = wrk.ActiveSheet
sht.Cells(1, 1) = "a"
sht.Cells(1, 2) = "b"
sht.Cells(1, 3) = "c"
sht.Cells(2, 1) = "'1"
sht.Cells(2, 2) = "'2"
sht.Cells(2, 3) = "'3"
wrk.SaveAs ("c:\test.xls")
xl.Quit
End Sub


can someons tell me if i can change a backgorund from a cell to