OPENING A FILE LOCATED IN A DIRECTORY DIFFERENT FROM CURRENT DIRECTORS

  • Thread starter Thread starter Steven R. Berke
  • Start date Start date
S

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.
 
try:
Workbooks.Open "\\bosdatar1\sberke$\nave\PGAMBOSTON.XLS"

in your VBA code



Francisco Mariscal
fcomariscal at hotmail dot com
 
Back
Top