Opening Multiple Workbooks

  • Thread starter Thread starter MISMitch
  • Start date Start date
M

MISMitch

I am new to VBA.
I am trying to open Multiple Workbooks that reside on a networked server.
The first book opens and my macro stops.
I do not have a problem when opening multiple books on my local C drive.

My code looks like below:

ChDir "Q:\MIS\ICSS\ICSSreports"
Workbooks.Open Filename:= _
"Q:\MIS\ICSS\ICSSreports\CSCMthly.xls"
Workbooks.Open Filename:= _
"Q:\MIS\ICSS\ICSSreports\CSCMnthly1.xls"

Any suggestions for problem isolation would be appreciated.
Mitch
 
Mitch,

The ChDir as you have it coded will not change the default drive.
If you're running this from the C: drive on your pc, it's quite possible
that you have a file named CSCMthly.xls on that drive but you don't
have CSCMthly1.xls

Anyway, to change the drive, use the following:
ChDrive = "Q"

John
 
Back
Top