how do i create excel files using VB?

Try this

Private Sub Command1_Click()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook, xldata, chrData
Dim xlsheet As Excel.Worksheet, xlName, xlRow, xlClm
             
    xlName = "c:\test.xls"
             
    Set xlApp = New Excel.Application
    Set xlBook = xlApp.Workbooks.Add
    Set xlsheet = xlBook.Worksheets.Add
    chrData = 67
    For xlClm = 1 To 3
    chrData = chrData + 1
    For xlRow = 1 To 4
    xldata = Chr(chrData) & xlRow
    xlsheet.Cells(xlRow, xlClm) = xldata
    Next xlRow
    Next xlClm
   
    xlsheet.SaveAs xlName
       Close #8
       
       xlApp.Quit
       
       Set xlApp = Nothing
       Set xlBook = Nothing
       Set xlsheet = Nothing

End Sub


cheers
Marcus

AStronus how did you go with my example did it help explain how to control excel from VB?