![]() RE: Excel Command Button Code Help SkipVought (Aerospace) 11 Jun 18 02:09 Adding and deleting the text files will allow us to see at a glance if anyone and who is using the 1 copy of the program that is licensed to us. The spreadsheet and the current buttons work well in our environment. ' Delete "Ram Elements IN USE.txt" and write new "Ram Elements EXIT.txt"Īs you guessed, I don't have a clue how to make it work other than how to write a comment line. ' Delete "Ram Elements EXIT.txt" and write new "Ram Elements IN USE.txt" ![]() "Ram Elements EXIT.txt" with one line of text that contains the active cell's contents.ĪctiveCell = Now() & " " & Environ("username") "Ram Elements IN USE.txt" with one line of text that contains the active cell's contents.Ģ. I would like each button to delete a small txt file and write a new txt file to the same folder that the spreadsheet was launched from.ġ. I have the code for 2 buttons that I would like to add a new feature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |