Gareth - Network analyst.
Guest
Adding a Dos command in EXCEL
Hi all
I dont know if this can easily be done But i hope it can and someone can
assist me.
I wish to add a command in a Excel spreadsheet
*ping* - Im sure you guys know the command Basically a Dos command the sends
packets and gets a responce from a system.
How i would like to do this is as follows.
I have a Rather Large database of systems and thier IP addresses Each has a
ID assigned
On a setion of this document i have a Collection of Vlookup and other
commands such as =(CONCATENATE(MID(C7,1,((LEN(C7))-2)),"6"))
ETC... What i would like to have is a Link that i simply need to click that
will ping the IP that is brought up for a Specific code that i enter. Lets
assume first which im sure will make things alot more simple what i want to
add is a command that executes a Ping with a IP that is located in a cell...
So something like *Ping commandline parameters* (C7) *(C7) being the
location of the IP address.
I hope you guys can assist me in this and im sure i'll want to kick my own
*** when i see how its done....
Thanks alot for the assistance.
Bookmarks