I have an issue which I do not know how to approach. Using QTP 9.5, I need to get some numerical data from my AUT, this information needs to be copied to an Excel file (an existing file)
This Excel has formulas which perform calculation on the data. Then I need to take other numbers from another column in a specific range and then paste them to a new Excel file (clean file).
How can I do this with QTP?
Should I use excel.application and try this way?
What would you suggest I do in this case?