title: Excel/VBA - Detect if server is reachable
body: <p>At my work place, different computers are in different subnets, and if the PCs are in the same subnet as the Samba server, I can reach the file server by going to <code>\\myserv\MyFolder</code>, but for the PC is in a different subnet, the only way for me to reach the server is by using IP <code>(i.e., \\1.2.3.4\MyFolder)</code>.</p>
  
  <p>I am just wondering in VBA, if there is any way I can say:</p>
  
  <p>if I can find the server using <code>\\myserv</code>, then use <code>myserv</code>, else use <code>1.2.3.4</code>?</p>
  
  <p>Unfortunately I can not tweak the network at all and I want to set up this way so that at least when the IP changes, majority of my users could still use the tool by visiting <code>\\myserv\MyFolder</code>.</p>