Hi it seems I've just been bitten by the VBA bug for the past few days I just can't seem to get away from my PC.
Anyhow this is my first post so please be gentle.
I wish to input data in one workbook and then want certain bits of this info to update in another workbook.
I want this info to write to the next available line.
This is what I've been playing around with, can someone please point me in the right direction.
'Update the Stats File
Set myBook = Workbooks.Open(Filename:="c:\Stats.xls")
myBookRow = [c:\Stats.xls]!Sheet1.Range("A65536").End(xlUp).Row + 1
Cells(myBookRow, 1) = Date
Cells(myBookRow, 2) = Now()
Cells(myBookRow, 3) = User
Cells(myBookRow, 4) = Sys
Cells(myBookRow, 5) = Des
Cells(myBookRow, 3) = TextBox1.Value
Thanks in advance.