| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save worksheet data to alternate closed workbook - next row | Excel Programming | |||
| Get Data From Closed Workbook | Excel Worksheet Functions | |||
| Save TextBox Entry after WorkBook is closed | Excel Programming | |||
| getting data from closed workbook | Excel Programming | |||
| getting data from closed workbook | Excel Programming | |||
Hybrid Mode
