LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default creating and saving data from a userform

Hello

I'm totally at a loss as to how I can achieve this, but this site has helped
me in the pass and I'm hoping you will be able to help me now.

I have an excel program which stays in a share drive. Staff are then able
to open up the excel program which is all VB. The first form they encounter
is to setup their signature block. There are four textboxes, Eg: name, state,
telephone etc. Currently when exiting out of this program their signature
block is not saved. I'm hoping to create a text document via notepad or
similiar file which would save their signature block in their own drive.

I thought of creating two command buttons, one to save and another to update
if needed. The save button would check in their own drive if there was such
as file (eg: signatureblock.txt) and if not would create on. The update
button would again check if there was such a file, it would either delete the
old one and then create a new one or create a new one.

I was hoping that next time that staff member opened the program, the
program would automatically extract the signature block information and place
this info appropriately in the correct textboxes.

I'm hoping for any guidance or assistance.
Many thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Userform as Gif Robert[_24_] Excel Programming 7 June 13th 13 05:12 AM
Saving information between uses? (Userform) PaulW Excel Programming 1 March 30th 07 02:31 PM
userform textboxes saving numerical data as text in worksheet buckchow[_3_] Excel Programming 0 January 16th 07 05:06 AM
Creating/Saving an .xla file aniamc Excel Programming 4 May 13th 04 11:31 PM
Creating a Data Entry Userform spurtniq[_8_] Excel Programming 1 January 8th 04 05:48 AM


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"