Good afternoon.
I am having real difficulty in changing my Macro to bypass the drive letter and use the drive name.
Basically, their are 20 people in my team which will require access to the file I have built. The macro in the file currently uses Z:\ as this is what my PC is set to. Others on the same drive (letter) the file works fine, however other are set to X:\ or Z:\ and the macro errors.
I have found the server name which is \\gbrcrotpc0c1002\Life_Ent by going into Programs/Accessories/Comand Prompt
I have pasted two examples below as I am by far experienced in using Macros (my first attempt to be honest).
The first one works with others on the Y:\ as mentioned above, the second is me trying to bypass the letter so regardless of which letter they have used, it can still access the file.
Please tell me there is a way of doing this, as I wont be able to get everyone to change their "letter".
Bookmarks