Userform question
 

Hi
I have created an userform that has text fields and option buttons.
On click of save button, I want the data of this form to be saved in an
workbook that is in a different folder (c:folder1\audit.xls). Please advise
how to write a code in VBA. I am using excel 2000. Also will there be any
problem if approx 5 users submit the form at once. Also I need to look at the
last row of data in the audit.xls and place the data in the next row.

Please advise