Did it VBScript not too long ago. The VB should be approximately the same. This code opens an input excel file and writes to an output excel file. You can create the excel output file from scratch byt changing the xlbook - some method of Workbooks will allocate a new workbook - but I leave that as an exercise for the reader:

' set up the excel file
Set xlapp = CreateObject("Excel.Application")
Set xlbook = xlapp.Workbooks.Open(Server.MapPath("myexcelinfile.xls"))
Set xlsheet = xlbook.Worksheets("RawData")
xlapp.DisplayAlerts = False

-- column headers in row 1
xlsheet.Cells(1, 1).Value = "My Column 1"
xlsheet.Cells(1, 2).Value = "My Column 2"

-- write out the data starting at row 2
xlsheet.Cells(2, 1).Value = 1.0
xlsheet.Cells(2, 2).Value = 2.0

' finish up the excel processing
xlbook.SaveAs Server.MapPath("myexceloutfile.xls")
xlbook.Close
xlapp.Quit
Set xlsheet = Nothing
Set xlbook = Nothing
Set xlapp = Nothing