Hello,
I'm trying to open another workbook, so that the second workbook just opens, but doesn't initially calculate.
Here's what I've tried, without success, the original workbook goes to Manual calculate, but the second one still opens as Automatic, and thus calculates when it opens.
Application.Calculation = xlManual
Application.Calculation = xlCalculationManual
Workbooks.Open ("T:\blah\blah\blah.csv")
Application.Calculation = xlManual
Application.Calculation = xlCalculationManual
Many thanks in advance should anyone be able to provide help.
I'm trying to open another workbook, so that the second workbook just opens, but doesn't initially calculate.
Here's what I've tried, without success, the original workbook goes to Manual calculate, but the second one still opens as Automatic, and thus calculates when it opens.
Application.Calculation = xlManual
Application.Calculation = xlCalculationManual
Workbooks.Open ("T:\blah\blah\blah.csv")
Application.Calculation = xlManual
Application.Calculation = xlCalculationManual
Many thanks in advance should anyone be able to provide help.