I have one issue realted to Automating multiple Excel File.
the Problem is as follows,
1. I have two excel File in the Script to be handled, file A and file B.
2. file A is my database for the script; whereas file B is an Object that I need to handle while my script is in execution.
3. Since I am using CreateObject Method I am not able to Close the runtime Excel File (file B) Instead of that (file A) is getting Closed.
Re: Excel Problem: Automation of Multiple Excel Fi
One solution could be to import your database Excel sheet into a QTP datatable when you start the script. You should then be able to attach to the Excel generated by the application via Tarun's suggestion and since there is only one, work on it with impunity.