Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print / Write to text file and usage of buttons
Hi gurus
I need to make an Excel vba to write to a log text file usage of certain buttons on a userform. So, when user clicks a button called "button1" on "userform1" this information should be added in the end of text file with date and username. There are two problems I can't solve and need you help with. a) how to write an event to a userform so that any button clicked runs program to save to log file. b) how to append to the file. I have used print and write for other purposes, but this should append and not overwrite. This is against news rules, but could you pls send your comments to jari.toukkari...jippii.fi because I have a limited access to news groups. Thanks in advance. Jari |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print / Write to text file and usage of buttons
instead of
Open "C:\FILEIO\TEXTFILE.TXT" For Input As #1 use Open "C:\FILEIO\TEXTFILE.TXT" For append As #1 In the click event of each button, call the procedure that writes the file. -- Regards, Tom Ogilvy " wrote: Hi gurus I need to make an Excel vba to write to a log text file usage of certain buttons on a userform. So, when user clicks a button called "button1" on "userform1" this information should be added in the end of text file with date and username. There are two problems I can't solve and need you help with. a) how to write an event to a userform so that any button clicked runs program to save to log file. b) how to append to the file. I have used print and write for other purposes, but this should append and not overwrite. This is against news rules, but could you pls send your comments to jari.toukkari...jippii.fi because I have a limited access to news groups. Thanks in advance. Jari |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel buttons to print out on pdf file and printer!! | Excel Worksheet Functions | |||
Open CSV file, format data and write output to a text file. | Excel Programming | |||
Write Text File | Excel Programming | |||
Text file to measure file usage | Excel Programming | |||
how to write other language in text file from VBA | Excel Programming |