Check if Connected to Network

[Cat129]

Hi All,

Could someone help me with the below please. I've googled as much as I can but everything I try gives me error messages.

I need my code to check if its connected to a certain network drive, if it is it will then save, it is isn't it will do something else

I am testing it on an networked laptop, I have tried all of the below but none are working

If Dir("\\mtcewymserver\sysvol\Database\Program_Binders\Pilot\Approvals") = "" Then

If Dir("\\mtcewymserver\sysvol\Database\Program_Binders\Pilot\Approvals") = <> "" Then

If Len(Dir("\\mtcewymserver\sysvol\Database\Program_Binders\Pilot\Approvals")) = "0" Then

All are giving me

Run-time error '52'
Bad file name or number

Can anyone help me where I am going wrong???

Thanks,
Cat

 

[Cat129]

I also forgot to say I have the server's IP, so is there a way to check if its connected this way as an alternative?

 

[Cat129]

Solved it