<div>
That is exactly what I was looking for. &nbsp;Thanks!
</div>


<div>
Thanks for the grade!<br />
It was a pleasure to help.<br />
<br />
regards,<br />
Jeroen
</div>


<div>
<div class="content wysiwyg-content">
I want to be able to ping from Excel 2007. &nbsp;Column A should be a list of computer names, column B should use CONCATENATE to put that computer name in a string &quot;ping -n 1 ComputerName &gt;&gt;&nbsp;C:\results.txt&quot;. &nbsp;I would like to make a macro that would run those pings in order, going down Column B. &nbsp;Is that possible? &nbsp;I haven't been able to find any information about running pings from Excel so far. <br />
<br />
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?
</div>
</div>


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?

That is exactly what I was looking for.  Thanks!

Thanks for the grade!
It was a pleasure to help.

regards,
Jeroen

How to run ping commands from Excel?

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 &quot;ping -n 1 ComputerName &gt;&gt; C:\results.txt&quot;.  I would like to make a macro that would run those pings in order, going down Column B.  Is that possible?  I haven&#39;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?

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.