To actually answer your question easiest thing to remember is that when dealing with excel you need to know the spreadsheet name, and cell location where you want the data. If your unsure you can also parse the excell sheet looking for where you want to place the data.
Another tip is that cells in excel are on a x,y grid. So a1 is actualy referenced as cell 1,1
Another tip don't forget to add in the Microsoft Excel Library in your projects references, again this might be VB 101 for you and your like DUH give me something I can use. So since you didn't specify if the template existed or didn't i'll give the ripped straight from Microsoft MSDN answer on creating a excel spreadsheet.
CODE
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet")
' Make Excel visible through the Application object.
ExcelSheet.Application.Visible = True
' Place some text in the first cell of the sheet.
ExcelSheet.Application.Cells(1, 1).Value = "This is Putting Data in column A, row 1"
' Save the sheet to C:\test.xls directory.
ExcelSheet.SaveAs "C:\TEST.XLS"
' Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit
' Release the object variable.
Set ExcelSheet = Nothing
'There are many other options you can do like rename sheets select a sheet by name some versions of VB
'allow you to also give the cell location as excelsheet.application.cells("A",1) or say
' excelsheet.application.cells("R","4")
| 