Save data to closed workbook

  • Thread starter Thread starter Do
  • Start date Start date
D

Do

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
 
One............A1:A10 is a column, not a row.

Suggest you explore the benefits of using the Template Wizard with Data
Tracking.


Gord Dibben MS Excel MVP
 
Back
Top