open excll from network

  • Thread starter Thread starter aneurin
  • Start date Start date
A

aneurin

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
 
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
 
You may want to use CommonDialog control to show file open
dialog box. Is gives flexibility to browse through any
drives.
 
There's no need for the Common Dialog Control with Excel..

DIM F=sFileNAme as string
SFileNAme = Application.GetOpenFilename()

see help on this method

Patrick Molloy
Microsoft Excel MVP
 
Back
Top