First of all, this type of work around should not be there in automation script which requires a manual intervention. you should identify why it is causing that issue, you may would like to sit with the dev to identify this. however if you need to put a workaround there, isn't it possible to do the same which you do manually i.e close the calendar and open it again through your script only.
for your code in the query, I have few questions
- what does worksheets.add do?
- if your script ignores it this could be an issue at calling the sub, make sure you have called the sub properly.
I believe the first statement is causing the issue. have you used 'On Error Resume Next' in your script? can you comment that out and check?
for your code in the query, I have few questions
- what does worksheets.add do?
- if your script ignores it this could be an issue at calling the sub, make sure you have called the sub properly.
I believe the first statement is causing the issue. have you used 'On Error Resume Next' in your script? can you comment that out and check?