Yes, you can use the UNC
On my network I have templates in
Z:\Templates
others on the system may need access so I use
\\bhapps1\TechHackers\template

here bhapps1 is the server and "TechHackers" is
the "share"

You can see these in your file exploere. Right Click on
Start and select Explore. When File Explorer opens,
select Tools then 'Map Network Drive'. In the Drive
Dropdown, you will see the mapped drives and their full
unc path.

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
hi I have searched goggle for the answer but cant seem
to
find it
is it possible to open an excel doc by a macro if you
don't not the drive letter i.e. c:\\
the reason I ask this is that I have an excel doc stored
on a network and I have mapped to this drive as d:\\ but
other people who have to use it have mapped to using a
different letter i.e. f:\\ , g:\\

Aneurin
.