OPENING A FILE LOCATED IN A DIRECTORY DIFFERENT FROM CURRENT DIRECTORS

[Steven R. Berke]

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.

 

[pancho]

try:
Workbooks.Open "\\bosdatar1\sberke$\nave\PGAMBOSTON.XLS"

in your VBA code



Francisco Mariscal
fcomariscal at hotmail dot com