Thread: workbooks.open
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cottrell Jim Cottrell is offline
external usenet poster
 
Posts: 2
Default workbooks.open

I would like to open 4 files with a macro. If I just open one file it works.
If I try to open more than one, I get a subscript out of range error.
Can you help me with this?
Thanks!

Workbooks.Open Sheets("files").Range("C3").Value
Workbooks.Open Sheets("files").Range("C4").Value