Populating an Excel sheet

[Dorothy]

I have an xls file at "C:\test.xls". I need to populate the xls file with values of a string array.

Help me out?

[cim3]

Just the same as in VB - add a reference to the excel object model.

Dim a As New Excel.Application()
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet

wb = a.Workbooks.Open("C:\book1.xls")

ws = wb.Worksheets.Item(1)

With ws
'populate titles
.Cells(1, 1).value = "Date"
.Cells(1, 2).value = "Location"

.Cells(2, 1).value = YOUR STRING VALUE
.Cells(2, 2).value = YOUR STRING VALUE
End With