"Run time error 1004-Method ‘Range’ of object’_Global’ failed" while executing an Excel macro - Unable to handle excel-pop ups

Hi - I am trying to Open a macro enabled excel using Excel application scope. But before the excel opens I am getting an error popup as shown in the screenshot. Unable to recognise and click End button on that popup. Tried parallel activities as well. Any suggestions?


did you check, if maybe your worksheet is protected? This may cause this error.
It maybe also due to lack of memory. Were you starting this macro in the past? Maybe it causes memory overflow.


Now it is displaying a new error.

“Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed”

Any idea as to when this popup appears. ?
Because i’m unable to reproduce this popup when i manually trigger the Macro. It worked fine on manual trigger. However it appears when triggered via “Execute macro” activity.

PS: I need to trigger this macro in Excel1, while Excel2 is opened.