|You can't write to a closed workbook.|
The code would have to open it, copy the row, save it and close it.
The code below will do just that.
If you hide log.xls (Windows...Hide) and then quit Excel, it will ask you if you want to save the changes to log.xls. Say yes. By doing that, you won't see log.xls open when you run the code.
When you want to look at log.xls, open it and then use Windows...Unhide so that you can view it. If you don't make any changes after viewing it, you don't have to hide it again, just close it without saving and it will remain hidden the next time the code runs. If you make changes that you need to save, then you'll need to hide it again and the quit Excel in order to save it.
Of course you could always write a macro to hide it, save it and close it so you don't have to quit Excel in order to save it as hidden.
Anyway, here's the code to copy Row 2.
Dim curName As String
Dim nxtRw As Integer
'Open log.xls (Hidden if saved Hidden)
'Determine next empty row in log.xls
nxtRw = Workbooks("log.xls").Sheets(1).Range("A" & Rows.Count).End(xlUp).Row + 1
'Copy Activeworkbook row to to log.xls
Application.CutCopyMode = False
'Save and close log.xls
Posting Tip: Before posting Data or VBA Code, read this How-To.