| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2007 - Can't open a file that is in use on the network | Excel Discussion (Misc queries) | |||
| Excel can't open network drive! | Excel Discussion (Misc queries) | |||
| excel does not open file in network | Excel Worksheet Functions | |||
| Is workbook open anywhere in network? | Excel Programming | |||
| excel template to open from network | Excel Programming | |||
Linear Mode
