Issue while working with two Excel (Marcos) sheets
I have encountered an issue when I working with two Excel (Macros) applications, only QTP recognizing activated excel but I want the other excel sheet to be activate when ever it requires.
Below steps are need to perform
Step 1:I have opened two Excel (Macros) Application by manually (Not with QTP).
Step 2:I want to fetch the data from first Excel (Macros) application through QTP.
Step 3:I want to insert the same fetched values in second Excel (macros) application through QTP
Step 4:I want to activate these two excel (Macros) applications simultaneously whenever required.
I would really appreciate if you could response back with suggestions and help me out in this regard.
Re: Issue while working with two Excel (Marcos) sheets
Running macros with two excel files will not work.
Because, Whenever there is a switch in excel the macro running in first excel will automatically get stopped. (limitation of excel).
If you want to do this other way..use VBScript.
Create two different/seperate objects of each excel.
This approach will surely work. If you need help on that let me know.