turn off autocalc

[barrfly]

I have a module that loops an open several hunderd other excel data files. Although I used the command

Application.Calculation = xlCalculationManual

it is still calculating eachtime one of these files is opened. Is there someting I can write in the module that will not allow the calcualting (which seriously slows down the subroutine.

Thanks

[Simon Lloyd]

Hi i use this with no problems but you may want to set the MaxChange = 0.0001 or something of that ilk!

With Application
.EnableEvents = False
.ScreenUpdating = False
.Calculation = xlCalculationManual
End With

Simon