open excll from network
 

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

open excll from network
 

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
.

open excll from network
 

You may want to use CommonDialog control to show file open
dialog box. Is gives flexibility to browse through any
drives.


-----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
.

open excll from network
 

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

-----Original Message-----
You may want to use CommonDialog control to show file
open
dialog box. Is gives flexibility to browse through any
drives.


-----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
.

.