UFT 12.02 – Excel listbox disappears when Object Spy is clicked on

  • Questions
  • UFT 12.02 - Excel listbox disappears when Object Spy is clicked on
Question ID: 106831
1
0

I am trying to create an object repository for testing a Data Cube in Excel. I can capture the "Data" tab and the "From Other Sources" button with no problem. However, clicking the "From Other Sources" button then presents a listbox, from which I am trying to select "From Analysis Services". However, as soon as I click on the Object spy to capture the listbox, it disappears. Any idea how to keep it on top until I’ve captured it?

Marked as spam
Posted by (Questions: 385, Answers: 52)
Asked on April 29, 2016 3:16 pm
8 views
Answers (1)
1
Private answer

Excel is not supported for automation. Instead, you would be limited to using the Excel Object Model. For details, here's a good link (with video): http://www.ufthelp.com/2013/05/working-with-excel-object-model-in-uft.html

Marked as spam
Posted by (Questions: 0, Answers: 733)
Answered on April 29, 2016 3:16 pm
I was able to get the test case to work using the Excel Object Model in conjunction with Record/Playback, and by removing the Object Repository I had set up.
( at April 29, 2016 3:17 pm)