How to do "ping" from VBA ?

• • Reply

  14 years ago

  by jgiddy

  John Giddy

  , Australia

  Joined 14 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.
  
  
  
  
  Report abuse