Excel Linking

[Joe]

I would like to link multiple files to my Excel workbook
to mutliple other excel files located on a server. I tried
to link them using the mapped drive letter and then nobody
else can open the links since they are not always mapped
to the same drive letter (there is no standard at this
time where I work). I know that there is more than one way
to do this. At first I though of using a UNC name for the
link and then I would have to type in dozens of UNC paths
for the files that I am creating. I alos do not want to
have to create the same drive mapping for everyone in my
organization since it is very large. Any help is
appreciated.

 

[Random]

Try mapping to the network path. For example, if your
G: Drive is linked to \\yourdc\public\ then you would replace all of
the instances of G:\ in your code with \\yourdc\public\

I have used this at my office as well since we are not universal yet.
This should work as long as everyone has read/write permissions to the
shared resource.