Find the drive letter of a mapped network drive

[billyjo182]

Does anyone have a piece of code that can help me find the letter of a mapped drive? I know the name of the drive, but the drive can be mapped to a different letter on each persons laptop who might run my macro. So I need a macro that looks for a drive letter associated with the name "\\secrets\"...

[alansidman]

Starting point: https://superuser.com/questions/3846...o-in-windows-7

https://social.msdn.microsoft.com/Fo...r?forum=isvvba

[Leith Ross]

Hello BillyJo,

The code below contains 2 macros. One to get the server path (UNC) from a mapped drive letter and the second to search all the drives in use on the computer and find a partial or complete match to the server name.

Add a new VBA module to your workbook and paste this code into it.

You would call the macro like this in your code...

Macro Calling Example

Please Login or Register  to view this content.

Module Code

Please Login or Register  to view this content.

[billyjo182]

Leith, you are a master. Much gratitude for taking the time for this!

[Leith Ross]

Hello BillyJo,

Mastery is born of both necessity and hard work. You're welcome.

[agent_maxine]

Dear Leith, thank you for the codes.

Can you perhaps point out which areas of the codes must be updated to be compatible with MS Excel 2016, 64-bit? The codes worked beautifully in my old setting (Excel 2013, 32-bit), but it is now returning a null value for the network drives. Specifically, it appears that the following values are now Zero.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

P.s. I did replace "Private Declare Function" with "Private Declare PtrSafe Function" for the 64-bit.

[alansidman]

@agent_maxineAdministrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread