View original (French)

Change the letter of a network drive

Solved
Informadream Posted messages 475 Registration date   Status Membre Last intervention   -  
 jess -
Hello,

I would like to know how to change the letter of my network drive (Z:) which points to a file server.

Let me explain:

I created a program in which I included hundreds of Excel macros that point to files located on this network drive (Z:\folder1\folder2)

Thus, when I run my program on my machine, everything works fine, but on another one it doesn't because the same file server (network drive) has different letters on each workstation, hence my need to modify them on some of these workstations.

Thank you for your help!

Best regards,

Informadream.

--
Knowledge is like jam, the more you have, the more you spread it.

2 réponses

Réponse 1 / 2
dje-dje Posted messages 10538 Registration date   Status Modérateur Last intervention   759
 
You just need to mount the Z: drive on all computers
Either via command line:
- If Z: already exists on the computer: net use z: /delete, then: net use z: \\server\mydirectory
- Otherwise: net use z: \\server\mydirectory

Or from an explorer:
Tool menu -> Map network drive
--

Some days you just shouldn't mess with me. And there are days like that every day!
Dje-Dje
4
jess
 
thank you, it's working perfectly
0