Stonesteel
Board Regular
- Joined
- Apr 27, 2010
- Messages
- 81
Greetings!
Seeking for help on how to use Wscript to reference an excel database, for example, i have a script here
now what I want is run a script that would change the ip address (colored in green) for everytime the "reset" ran. I have an excel file that has 12,000 ip addresses I would like to reset, so basically I will run a script that will loop and enter new ip address for every successful reset.
Seeking for help on how to use Wscript to reference an excel database, for example, i have a script here
Code:
[FONT=Lucida Console][SIZE=1]Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "cmd"
WScript.Sleep 500
WshShell.SendKeys "telnet [COLOR=green][B]172.27.225.6[/B][/COLOR]"
WScript.Sleep 500
WshShell.SendKeys "{ENTER}"
WScript.Sleep 2000
WshShell.SendKeys "admin"
WScript.Sleep 300
WshShell.SendKeys "{ENTER}"
WScript.Sleep 300
WshShell.SendKeys "[/SIZE][/FONT][EMAIL="C@n0pyBRo_NL"][FONT=Lucida Console][SIZE=1]C@n0pyBRo_NL[/SIZE][/FONT][/EMAIL][FONT=Lucida Console][SIZE=1]"
WScript.Sleep 300
WshShell. SendKeys "{ENTER}"
WScript.Sleep 300[/SIZE][/FONT]
[FONT=Lucida Console][SIZE=1]WshShell.SendKeys "reset"
WScript.Sleep 300
WshShell.SendKeys "{ENTER}"
WScript.Sleep 300[/SIZE][/FONT]
now what I want is run a script that would change the ip address (colored in green) for everytime the "reset" ran. I have an excel file that has 12,000 ip addresses I would like to reset, so basically I will run a script that will loop and enter new ip address for every successful reset.