Hi,
I'm importing data using the Workbooks.OpenText VBA method in Excel 2007. The problem is that for a reason it automatically re-calculates my active workbook even though I've set the calculation option to Manual. Since the re-calculation takes a while, I would like to avoid it at this stage.
BTW, I've tried to put those commands prior to OpenText but I still get the same result.
Application.Calculation = xlCalculationManual
and
Sheets(1).EnableCalculation = False
Thanks!
I'm importing data using the Workbooks.OpenText VBA method in Excel 2007. The problem is that for a reason it automatically re-calculates my active workbook even though I've set the calculation option to Manual. Since the re-calculation takes a while, I would like to avoid it at this stage.
BTW, I've tried to put those commands prior to OpenText but I still get the same result.
Application.Calculation = xlCalculationManual
and
Sheets(1).EnableCalculation = False
Thanks!