sending data from one workbook to a closed workbook

[Newport Count]

Hi,

currently I have an excel workbook (qwerty.xls) that has several worksheets. On one worksheet (workA) there is a macro button that opens up a userform. On the userform is a button (cmdSaveData) to send data (once complete) to a different worksheet (workB) in the same workbook (qwerty.xls).

My code is as follows:

Private Sub cmdSaveData_Click()
ActiveWorkbook.Sheets("workB").Activate
    Range("A2").Select
    Do
    If IsEmpty(ActiveCell) = False Then
        ActiveCell.Offset(1, 0).Select
    End If
    Loop Until IsEmpty(ActiveCell) = True

This works fine (i'm no expert on this at all but have worked out how to get this to work as i want to!) but now i need to enable my code to send the data to a completely different workbook (dvorak.xls).

Is this possible and can different people own their own versions of qwerty.xls (saved as diff names of course) to send to the same workbook (dvorak.xls) at the same time? maybe the workbook would have to be closed so that it could be opened and saved when available?

thanks in advance for any advice

cheers