turn off autocalc
 

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

Application.Calculation = xlCalculationManual

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

Thank

--
barrfl

Excel User - Energy market
-----------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...nfo&userid=414
View this thread: http://www.excelforum.com/showthread.php?threadid=37689

turn off autocalc
 

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

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=37689