Wrox Programmer Forums
|
BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2
This is the forum to discuss the Wrox book Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, Michael Alexander; ISBN: 9780470046432
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 27th, 2010, 05:16 AM
Registered User
 
Join Date: Sep 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Getting results from Ping command... into XL

Hi,
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.

But....

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...
/Patric





Similar Threads
Thread Thread Starter Forum Replies Last Post
ping in c++ assareh C++ Programming 10 August 5th, 2009 10:15 AM
Help In using XL wunnavabk VB.NET 2002/2003 Basics 17 May 11th, 2007 08:29 AM
Copying Xl sheet from one Xl file to another kesavan Excel VBA 1 July 3rd, 2006 10:11 PM
Ping another computer Phreaky .NET Web Services 0 January 18th, 2006 11:08 AM
Stored Procedure/Command Object results differ John K. King Access VBA 0 November 20th, 2003 11:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.