excel make connections with VBA (ping's)

Question

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!

cs_MPi · Answer

You will have to use the Shell function with a >Filename
to write the result in a file.
Then you have to read this file and retreive what you need to put in B1 cell

That's what I think ...

MPi²

cs_guif · Answer

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

Excel make connections with VBA (ping's)

2 réponses

Votre réponse