Network Connection

[austin350s10]

Is there a script to check if a fileserver connection is valid or not.

If a valid connection is detected then continue with other code. If not then exit sub.

This is to test if the user is plugged into the network at the office verses at home.

The letter drive I am trying to test for is S:

Is there a way to just test the connection to a mapped network drive?

 

[AlphaFrog]

Maybe try something like this...

If Dir("S:\", vbDirectory) = vbNullString Then Exit Sub

It should exit sub if it can't find S:\