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.

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