Kindly keep this excel application scope first and keep it open from the beginning while then use excel application scope and open the one where we need to click on the macro button
Like one after the another and not inside one another
—the coming to error
Kindly have a view on this error
Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @SudhakarAs92