Hi, radhika,
please check that you open the Macro with the right MS Excel VBO. This often happens if you have several MS Excel VBOs in your Blue Prism environment and you call Create Instance Action with MS Excel VBO 1 and then call Macro with Action from MS Excel VBO 2.
Regards,
Zdenek