Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 9 of 9

Thread: Ping IP In Cell With VBA

  1. #1
    Join Date
    11th December 2007
    Posts
    3

    Ping IP In Cell With VBA

    Hi!
    I have a button in excel and I have two cells.
    -in cell A1 i have a name of computer or an IP.
    -in cell B1 i would like to make the result.

    If i have a click in the button, i would like to make a "ping -t host_name" and put the result "on line" or "off line" in the cell B1.

    Is it possible??
    very thank's!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,512

    Re: Ping With Vba

    Take a look at the possible answers above.

    Regards,
    Ger
    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

  3. #3
    Join Date
    2nd November 2005
    Location
    Tecumseh, OK
    Posts
    1,092

    Re: Ping With Vba

    Not sure why you would want to use the -t switch. It will require user action to end that ping.

    At a DOS prompt type:
    Ping ozgrid.com > c:\ozgrid.txt

    And view the results. You can use Shell to execute the command and then text reading methods to read the txt file. You need an example for each scenario. In other words, what line in the text file shows a connection and which does not and which shows invalid address to ping.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    Re: Ping IP In Cell With VBA

    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

  5. #5
    Join Date
    11th December 2007
    Posts
    3

    Re: Ping IP In Cell With VBA

    oh! it's very important.. If the computer disconnected the B1 puts to Off line and if it's reconnected puts On line.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Ping IP In Cell With VBA

    What is MORE important is that you at least acknowledge those that are TRYING to help you as apposed to totally ignoring them!

  7. #7
    Join Date
    11th December 2007
    Posts
    3

    Re: Ping IP In Cell With VBA

    I write in CMD "Ping -t hostname > c:\ping.txt"
    this ping is continuos and it's very real for me.
    Is it possible that use a macro to learn this file (ping.txt) and delete the file when I click at my button "stop_" ?

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    19th August 2010
    Posts
    1

    Re: Ping IP In Cell With VBA

    You can test the ping test here http://www.ip-details.com/ and also get the ip address,ip search,domain host search,get ip details....

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,512

    Re: Ping IP In Cell With VBA

    Hi Sushmaa - welcome to the forum - there is no need to re-open threads which are 3 years old.

    Best Regards,
    Ger
    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 5
    Last Post: May 8th, 2008, 01:44
  2. Ping IP Address Residing In a Cell
    By charlesa920 in forum EXCEL HELP
    Replies: 4
    Last Post: December 11th, 2007, 05:09
  3. Ping a Computer
    By nojy in forum EXCEL HELP
    Replies: 5
    Last Post: July 27th, 2005, 20:15
  4. VBA: stripping text from PING output
    By MisterT in forum EXCEL HELP
    Replies: 2
    Last Post: August 31st, 2003, 23:06
  5. Matrix Ping Pong (link)
    By Egad in forum Test Area
    Replies: 0
    Last Post: July 12th, 2003, 12:16

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno