Referencing Shared Drive in VBA

I am trying to write a macro which opens a file in a specific location on a shared drive, however different computers on the network have mapped this drive to different letters, e.g. G:\ H:\ etc. As the file path will vary depending on this letter, the path I manually include in the code will not work unless the user has the same mapping as me.

What I would like to know: is there a way to determine what letter this drive is mapped to in VBA, and therefore to assign this to a variable "DriveLetter" and change the file path to DriveLetter & ":\FilePath"?

Any help would be very much appreciated.

I may end up having to do it this way, but i'm hoping for an automated way as some users are not tech savvy and may not know the answer to that.

Unfortunately it will be distributed as an attachment via email.

Thank you AlphaFrog, exactly what I needed!