I want to be able to ping from Excel 2007. Column A should be a list of computer names, column B should use CONCATENATE to put that computer name in a string "ping -n 1 ComputerName >> C:\results.txt". I would like to make a macro that would run those pings in order, going down Column B. Is that possible? I haven't been able to find any information about running pings from Excel so far.
Also, if it is possible to run the pings, would it be possible to have the results put in Column C for that computer name?