I have an Excel application scope opened which has 7 command buttons to invoke different macros. While invoking them I need to have another excel file to be opened.So I’v used Excel application scope-2 inside the first one and invoked macros.
But it is not running the macro, instead it throws the below error window. But strangely macro executes while run it manually. Where could it have failed?