Stephen Jones
New Member
I would say that you should put a pause in-between your open workbook and get worksheet as a collection. The fact that it only happens when running in the control room is a big clue.
There is a 1 second gap between opening the workbook and getting the worksheet as a collection, it may be that on the odd occasion the excel workbook has not opened before you attempt the collection part.
There is a 1 second gap between opening the workbook and getting the worksheet as a collection, it may be that on the odd occasion the excel workbook has not opened before you attempt the collection part.