The blank lines may be because it starts the insert from the end of the Excel file. Although there was no data in the excel file, the xlCellTypeLastUsedCell property may still have been set. Try deleting the spreadsheet and creating a new one with the same name.