Problem with users with different mapped network drives

[atrium]

I need to make sure that all users on the network can access a specific network drive folder.
Most users don't have a problem but some users have the network drive mapped differently so when running the feature required their system can't find the file at that specified location.
I have the location of the files hard wired into the VBA code.
eg. Z:\INVDATA\COMPANIES\CompanyA\ASSETS Pty Ltd\Precedents 2015\STAGE 3A - COLLS-DEMS\
The location is outside of the project address.

I need to be able to make sure the address of the folder is the same for all users. Any help would be appreciated.

Atrium

 

[pbaldy]

In geneneral, use a UNC path rather than a mapped drive:

\\ServerName\INVDATA\COMPANIES\CompanyA\ASSETS Pty Ltd\Precedents 2015\STAGE 3A - COLLS-DEMS\

 

[atrium]

Thanks heaps pbaldy. Fixed my problem

 

[pbaldy]

Happy to help!