File Path Question??

[austin350s10]

I have workbook setup that uses a set of variables stored into stings. The way I have this script working right now is the variable becomes part of the file name when saving
. Ex. File Name: "2010-Assessment-Data- For-" & (Var1) & (var2) & ".xmls"

I was able to make this set-up work and save the file to the desktop but I am looking for a little more. I want to be able to save this file to a network path like: "S:/Clients\Holding File\**Files**"

Does anyone know first who to test if the S: network is even active?
If no network active then create a folder on the desktop Named: "Clients" Even if its already there "Prompt to overwrite"

Can this be done while at the same time allowing the users an out "Exit Sub"

Any ideas would great,

-Austin-

 

[WinteE]

Try this :

    Set objFSO = CreateObject("Scripting.FileSystemObject")
        
    If objFSO.FileExists("S:\Clients\Holding File\*") = True Then

    End If

Success,
Erik

 

[austin350s10]

The above does not seem to work correctly. I am not sure if it makes a difference but the path I am checking for is from a fileserver in the office. I just need a script to check if the connection to the S: drive is valid or not.

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

I know for a fact that the full file path of S:/Clients/Holding File is on the S; drive because I am the one who controls what files go on the server.

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