Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Multiple Workbooks
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 MISMitch wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening multiple excel workbooks at once | Excel Discussion (Misc queries) | |||
Opening new workbooks | Excel Discussion (Misc queries) | |||
Opening multiple workbooks in Excel | Excel Discussion (Misc queries) | |||
Opening Multiple Workbooks | Excel Discussion (Misc queries) | |||
Opening multiple workbooks in separate screens | New Users to Excel |