need help to invoke windows explorer in background from excel using VBA

[SK-2006]

Hi,
In our project we generally store critical documents to a client location. For this we map one of our drives to this location which would something like \\2.24.23.2\client\abc.

I am creating a macro using VBA which earlier used to internally change the drive using cd K:\docs and then i used to place documents. note:- here K: drive points to \\2.24.23.2\client\abc link.

Now the problem is many users would be using this macro, and each one has a different alphabet mapped drive, ie not necessarily K:

So I found that through windows explorer, I can access the link directly provided one of my drives is mapped to this location and through macros if I can invoke windows explorer and access this link, then all other users can also make use of this macro irrespective of what alphabet they have kept for this location.

Is it possible to invoke windows explorer in the background
and access this link?

Thanks in advance..
Regards,
SK

 

[Bodisathva]

You don't have to use the mapped drive notation if you have the UNC address, just use the UNC.

 

[SK-2006]

Thanks, it worked.
I directly used the address in file copy statement instead of that notation.

Regards,
SK