View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vlado Sveda Vlado Sveda is offline
external usenet poster
 
Posts: 50
Default Referencing Range in UnOpened Workbook

Hello Gurus !

I need your help to solve my performance problem: I'm processing ~600
workbooks in a loop (punctually saying in 10 loops).
So I use ~6000 times construction like this:

....
Workbooks.Open MyCostsPath & Budget(i)
Set MyRange = Range("MyRangeName")

For Each MyCell In MyRange.Cells
....
....
Next MyCell
.....
ActiveWorkbook.Close

Is it possible to do it without opening workbooks ?
Thanks in advance !

Vlado Sveda