Am trying to automate a feature in application where we upload data from Excel. When we select to upload data, a login input message appears.

Since QTP is not recognizing Excel menus etc as standard objects, I have a macro which in turn calls the required function.

But am stuck again as QTP doesnt exit the macro and enter credentials when required. It waits for macro to complete.

When this macro is run, login credentials for the application are requested. When run using QTP, the handler is not exiting the macro and getting back to enter credentials. QTP waits at macro execution and is not able to enter the credentials.

Can you please help me out with the apt solution?

I need something to initiate a macro and get back to work without waiting for macro to complete.

Thank you