Save data to closed workbook
 

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

Save data to closed workbook
 

No suggestions...?

John



"Do" skrev i en meddelelse
...
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

Save data to closed workbook
 

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

On Wed, 17 Nov 2010 20:16:21 +0100, "Do" wrote:

No suggestions...?

John



"Do" skrev i en meddelelse
.. .
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