Getting results from Ping command... into XL
I want to get results from a ping and either place the resonse time or the text "failed" in a cell in excel.
I have managed to execute both "ping 127.0.0.1" or a .bat file.
Is there any way to get the output from the command into a string?
after that it will not be hard to handle the result, i only have problem getting the result string...
I have noticed that:
resp = Shell("ping 127.0.0.1", vbNormalFocus)
makes resp= ProcessID och that ping process....
Hope someone can help me...