I've previously asked about finding where my long program is stopping.
I've used several Debug.print lines in the code to find where this is
happening..........and it stops just after the line following 1By.....
.EnableEvents = False
.ScreenUpdating = True
.Calculation = xlCalculationManual
Debug.Print "1Bx" '++++++++
Debug.Print "1By" '++++++++
\Statistics\book" & xxx & ".xlsx", False, , , , True
Debug.Print "1Bz" '++++++++
.ScreenUpdating = False
.EnableEvents = True
It loops through the above about 40 times, opening different books -
it doesn't always stop when trying to open the same workbook. Since
finding the problem I've added in the methods (.EnableEvents =
False / .ScreenUpdating = True / .Calculation = xlCalculationManual)
to try to sort things out but it is still occuring.
All the above happens in a second instance of Excel.
Any help much appreciated