| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPENING A FILE LOCATED IN A DIRECTORY DIFFERENT FROM CURRENT DIRECTORS
I have afile whose name is "PGAMBOSTON.xls" it is stord on the FDrive
in a directory named NAVE and this is the path. "\\bosdatar1\sberke$\nave\PGAMBOSTON.XLS". I want to open this file when I am on the C Drive. Would you please tell me how to open the PGAMBOSTON file. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
OPENING A FILE LOCATED IN A DIRECTORY DIFFERENT FROM CURRENT DIRECTORS
try:
Workbooks.Open "\\bosdatar1\sberke$\nave\PGAMBOSTON.XLS" in your VBA code Francisco Mariscal fcomariscal at hotmail dot com -----Original Message----- I have afile whose name is "PGAMBOSTON.xls" it is stord on the FDrive in a directory named NAVE and this is the path. "\\bosdatar1\sberke$\nave\PGAMBOSTON.XLS". I want to open this file when I am on the C Drive. Would you please tell me how to open the PGAMBOSTON file. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a spreadsheet recognize the current directory it is in? | Excel Discussion (Misc queries) | |||
| open file in current directory | Excel Worksheet Functions | |||
| open file in current directory | Excel Discussion (Misc queries) | |||
| current directory | Excel Discussion (Misc queries) | |||
| Current Directory | Excel Discussion (Misc queries) | |||
Hybrid Mode
