Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ass when i see how its done.... Thanks alot for the assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a Dos command in EXCEL
See:
http://groups.google.com/group/micro...b7bd91d6438a88 -- Gary's Student "Gareth - Network analyst." wrote: 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 ass when i see how its done.... Thanks alot for the assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a Dos command in EXCEL
Thanks for that But now another Question. is there a Easier way. i kind dont
have a Programing knowladge that is helpful at this point. sorry. "Gary''s Student" wrote: See: http://groups.google.com/group/micro...b7bd91d6438a88 -- Gary's Student "Gareth - Network analyst." wrote: 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 ass when i see how its done.... Thanks alot for the assistance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a Dos command in EXCEL
Not that I amd aware of
-- Gary's Student "Gareth - Network analyst." wrote: Thanks for that But now another Question. is there a Easier way. i kind dont have a Programing knowladge that is helpful at this point. sorry. "Gary''s Student" wrote: See: http://groups.google.com/group/micro...b7bd91d6438a88 -- Gary's Student "Gareth - Network analyst." wrote: 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 ass when i see how its done.... Thanks alot for the assistance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a Dos command in EXCEL
Dont suppose i would be lucky enough to have someone that Got loads of time
to blow and feel like typing out a Coding that i can just copy and past then into Excel 2003 VB plugin that just needs me to click the link and all it does is start a ping with a IP that is desplayed in cell C7 just needs to display the ping, no report printouts, or saving the info anywhere nothing just execute Ping with IP in cell C7 and display the normal Dos box with the results..... "Gary''s Student" wrote: Not that I amd aware of -- Gary's Student "Gareth - Network analyst." wrote: Thanks for that But now another Question. is there a Easier way. i kind dont have a Programing knowladge that is helpful at this point. sorry. "Gary''s Student" wrote: See: http://groups.google.com/group/micro...b7bd91d6438a88 -- Gary's Student "Gareth - Network analyst." wrote: 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 ass when i see how its done.... Thanks alot for the assistance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a Dos command in EXCEL
Hi Gareth:
If you can put your ping commands into a batch (.bat) file, we can show you how to drive the commands from Excel and capture the information. -- Gary''s Student "Gareth - Network analyst." wrote: Dont suppose i would be lucky enough to have someone that Got loads of time to blow and feel like typing out a Coding that i can just copy and past then into Excel 2003 VB plugin that just needs me to click the link and all it does is start a ping with a IP that is desplayed in cell C7 just needs to display the ping, no report printouts, or saving the info anywhere nothing just execute Ping with IP in cell C7 and display the normal Dos box with the results..... "Gary''s Student" wrote: Not that I amd aware of -- Gary's Student "Gareth - Network analyst." wrote: Thanks for that But now another Question. is there a Easier way. i kind dont have a Programing knowladge that is helpful at this point. sorry. "Gary''s Student" wrote: See: http://groups.google.com/group/micro...b7bd91d6438a88 -- Gary's Student "Gareth - Network analyst." wrote: 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 ass when i see how its done.... Thanks alot for the assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Adding footnote to cell in Excel | Excel Discussion (Misc queries) | |||
adding characters in excel column | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel Adding duplicated numbers together | Excel Discussion (Misc queries) |