QTP and MS Excel

Question ID: 105459
1
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 (Questions: 28, Answers: 0)
Asked on June 30, 2014 9:17 pm
6 views
Answers (2)
2
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 (Questions: 2, Answers: 425)
Answered on July 9, 2014 3:17 pm
1
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 (Questions: 2, Answers: 98)
Answered on June 30, 2014 9:18 pm