View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MISMitch MISMitch is offline
external usenet poster
 
Posts: 2
Default Opening Multiple Workbooks

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