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

auto save when form is closed 6
Excel crashing when trying to close a workbook 0
Fastest way to save workbook 0
Save TextBox Entry after WorkBook is closed 1
write data to a closed file on network drive 13
VB Code to save a copy of the workbook as another name 2
Getting value from closed workbook 1
I want to Split & save the data in different workbook 35

Top