Hello all - have searched the boards to death but I'm still getting thi
issue - help massively appreciated :)

I have a large "calculations" spreadsheet which needs to open some CS
files. I have the code sorted to do all that, e.g.

Application.Calculation = xlCalculationManual

then I do this code just to open a file - it's a CSV file which open
directly:
Workbooks.Open Filename:= _
"L:\FTP_ROOT\RISK_TST\Reports\rpt_013_liabilities. c sv"


then the code goes on to do some calcs and so on...

There are about 5 sheets to open and then later close.

THE PROBLEM: Excel calculates the WHOLE CALCULATIONS spreadsheet when
open the CSV file, even though calculation is off. I can only assum
this is part of the way that I've opened the file. :-S

Please help - it takes Soooooo long to recalculate the entir
spreadsheet now and what I do with the rest of the very long macro i
to make it calculate only the sections it needs - i
range("x").calculate or sheets("y").calculate and so on. This bit work
fine though.

So - how do I make a CSV file open -without- recalculating?

Thanks so much for your help :

--
gearo
-----------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=39907