I have a spreadsheet with some ip addresses in it that I would link to issue a "ping" command for, parse the results and put the results in a different worksheet. I am able to use WScript to execute the command and get the results back in variable but there is a very annoying window that pops up and then disappears. I assume that it is the window that comes up when you run "cmd" from the Windows start button.

Is there a way to not have the window come up. If I use run I can not get the output into the variable.

Thanks