How do add a row to a xls spreadsheet before saving it

See more:

VB

how i add a row to an existing/opened spreadsheet. i don't want to create a new spreadsheet everytime. i have tried this code:

oSheet.range ("A2").value = txtOrderNumber.text
oSheet.range("B2").value = txtQuantity.text
'Save the workbook
oBook.saveas(fileName)
oSheet = Nothing

The idea here is to open a spreadsheet once and add information to it until end of day. Please help!!

Thanks