VBA to check and see if network drive is mapped

Hello again, Gurus.

I have a macro used by several people on different computers that saves a file to our network. From time to time, for reasons unknown, some users may lose connection to the mapped network drive. I need to begin the Macro with a check to see if the drive is available to the user, and if it isn't available give a message, "The PO Tracking Drive is not available. Please contact your System Administrator.", and then end the macro.

The network drive is \\fs950o\PO Tracking, and the drive letter is "M".

Thanks in advance for any help you can offer.

Hutch

Have you tried simply using Dir?

You could probably also use ChDrive with an error trap:

on error resume next
chdrive "M"
If err.number <>0 then
   Msgbox "M drive not mapped"
   Exit sub
End if
On error goto 0