Hi

Excel 2000.

I have an xlt-file which i wanna use for logging calls with a short
description of the call, ie. time, names etc. This data is entered in a
userform containing about 10 textboxes. Now i want to save this data when
clicking the userforms "ok" button.

What i need to do is:

-Textbox1 contains a unique ID number XXX.
-Check if C:\prg\XXX\logxxx.xls exists.
-If it exists, open the file and save textbox values to first empty row (ie.
A1:A10, next time B1:B10). Then close file. No screenupdating.
It it doesnt exist, create C:prg\XXX\logxxx.xls and do as above.

Any help is greatly appreciated! Thx!


John