Check a drive for availability

[426Hemi]

Is there another way to check a drive other than the Dir command? Dir works for me only when the computer I am trying to access on the network is up and running, otherwise, I receive an error. If the cpu I am trying to access is up and running, this code works

[
availTest = Dir("the path + filename is placed here")

If availTest = "" Then 'empty, no file found

'I send a msg to the user here and exit the procedure

Else

'Access and use the file

End If
]

 

[PHV]

You may try this:
availTest = CreateObject("Scripting.FileSystemObject").FileExists("the path + filename is placed here")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[426Hemi]

Thank you for your help, that did the trick!