Howdy!

I want to update a test.xls file. I can open Excel97 and open the file I want, but how do you set the Sheet and add values per cell using vb6.

here's what I have so far

Dim MyXL As Object
Dim ExcelWasNotRunning As Boolean

Set MyXL = GetObject(, "Excel.Application")
if Err.Number <> 0 Then ExcelWasNotRunning = True
Err.Clear

Set MyXL = GetObject("C:\test.xls")
MyXL.Application.Visible = True
MyXL.Parent.Windows(1).Visible = True

For example I want to add "hello" to cell B13

If you can help, Thanx