Change the letter of a network drive
Solved
Informadream
Posted messages
475
Registration date
Status
Member
Last intervention
-
jess -
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.
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 answers
-
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