BackTrackPasswords.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Password | UserName | Company | EmailAddress | Add | Remove | ||
2 | bu0OB1PT | AMPMTowing | AMPMTowing | Add | Remove | |||
3 | K9Yk7Lp0 | MMTowing | M&MTowing | Add | Remove | |||
4 | 779H8PrL | PJTowing | PJ'sTowing | Add | Remove | |||
5 | WW5Qn5Y5 | LouiesTow | Louie'sTowing | Add | Remove | |||
6 | H8jW6tKa | OscarTow | Oscar's/WaikemTowing | Add | Remove | |||
Sheet1 |
Ok... What I would like to do is make it so the add buttons and remove buttons do certain commands.... I tried using vbscript to make a standalone app to add
'NewBackupUser
Dim WshShell
Dim Message
Dim Title
Title = "Create New Backup User"
Set WshShell = WScript.CreateObject("WScript.Shell")
Name = InputBox("What would you like the username to be. Must be less than 20 characters and can
not contain \/:*?<>: or quotation marks",Title,"USERNAME", 4000, 2000)
Password = InputBox("What would you like the username to be. Must be less than 14 characters and
can not contain \/:*?<>: or quotation marks",Title,"PASSWORD", 4000, 2000)
Email = InputBox("What is the email address?",Title,"Email address", 4000, 2000)
WshShell.Run "RemoteManagementClient.exe xx.xxx.xxx.xx.x TapeStor CREATE " & Name & " "
& Password & " "" & Email & "" " & Email
Wscript.Echo "Done"
but I want the add button to do all that and instead of it prompting for username and password I want it to get them from their cell in the sheet... any ideas?
Code:
Code: