QTP and MS Excel
| ♥ 0 |
Have you ever had any success with using QTP to automate an Excel form? I was able to pull it up and based on what I can see, QTP is unable to identify those type of objects. I click on the Excel window trying to add objects to the obj repository. I asked it to add all child objects, and the list was very small. It could not see what was on the form. I don't know if HP offers any type of add-on to allow QTP to do this. I doubt they do. You might want to inquire with them though. A Google search on the subject didn't return much information..
Marked as spam
|
Posted by |
Private answer
You can take a look at the extensive documentation regarding the Excel.Application object model. You can instantiate the Excel object using a CreateObject, such as: Set ExcelObject = CreateObject(''Excel.Application'') http://msdn.microsoft.com/en-us/library/bb978780(v=office.12).aspx If this is too difficult, you could also look at using Virtual Objects in the application. Marked as spam
 Posted by rich-text (Questions: 2, Answers: 477) Answered on July 9, 2014 3:17 pm
|
|
|
Private answer
HP does not state in ''HP QuickTest Professional 11.00 Product Availability Matrix '' or the ''Unified Functional Testing 00 Product Availability Matrix '' document that it supports Microsoft Excel Forms. However I have seen other users use Excel Automation Object to automate forms. I do not have any experience with automating Excel forms. Marked as spam
 Posted by bubblehead712 (Questions: 2, Answers: 98) Answered on June 30, 2014 9:18 pm
|