Advice on setting up path in a network enviroment.

[jaredchristiansen]

Hi All,
Thanks in advance for any help with this!
So there is probably an easy solution for this but in my stupidity I can’t find it. I am working on setting up various workbooks in a network environment with macros that are dependent on the correct paths to other workbooks and files. I’m building these in a network drive that has been mapped out with the Letter N for the drive letter so the path in all my macros are set up as follows example: (N:\Filename\workbook.xls) the problem is that not everyone that will be using these workbooks has this network file mapped as the N drive on their individual work stations. So my question is how do I set up the path in the macro so that it works for everyone?

 

[Joe4]

Use the full network name and path (UNC naming convention) in all your references.

For example, if "N" was mapped to the "Sample" folder on the server named "Server01", instead of referencing of a file named "MyFile.xls" like this:
N:\MyFile.xls
reference it like this:
\\Server01\Sample\MyFile.xls

Then it doesn't matter what mapped drives a user has. As long as they have access to those locations on the network, it will work for them.

 

[jaredchristiansen]

Sweet! Thanks! I'll try this and let you know how it worked thanks again!