Consider using ADO to load a text file into a Recordset object. Then open the workbook, find the last row on a sheet and paste the recordset to the row immediately below it (the Range object has a method 'CopyFromRecordset' that pastes a recordset to the worksheet at the cell specified).