How to do "ping" from VBA ?

  • 13 years ago
    I have a VBA project which downloads some files from a remote server using FTP and then goes on to do other things. If the remote server is offline, the time delay while the connection attempt times out is annoying, and I would like to use something like the "ping" DOS command to determine if the server is available before trying to connect.
    However, I don't know how to do this, and how to return a variable from the "ping" which VBA can use in an "IF.. " statement.
    Any suggestions greatfully received.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Computer Science is no more about computers than astronomy is about telescopes.” - E. W. Dijkstra