Run Macros thro QTP
I read in few forums how to run macros thro QTP, my question is if i create a new instance of excel from QTP how do i write a macro on that excel or run a macro. To be more precise, how should the macro be stored and invoked thro QTP. Why I am asking this question is I created a macro in excel and made it PERSONAL, hence i was able to call in any excel i open, but i could not call this macro when i create an excel instance thro QTP. Kindly help how to proceed on this.
Thanks in advance.