Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Userform as Gif | Excel Programming | |||
Saving information between uses? (Userform) | Excel Programming | |||
userform textboxes saving numerical data as text in worksheet | Excel Programming | |||
Creating/Saving an .xla file | Excel Programming | |||
Creating a Data Entry Userform | Excel Programming |