Save data to closed workbook

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save TextBox Entry after WorkBook is closed 1
I want to Split & save the data in different workbook 35
SetFocus to first textbox on userform upon Userform1.Show 6
Run-time error 57121 & 32809, Excel 2003 SP2 2
HELP ListBox Save Data to Hidden Sheet, and ReLoad It upon opening 2
Can I save "Data Text to columns" definitions 1
Need FASTEST way to get data from a large closed Excel File 13
A Better Way to Reorganize Data? 5

Top