Unable to Click on Excel Dialog

[Raj20091]

Hello,
I am opening an excel and changing a value. When I change the value I get a dialog box(based on validations)

Code

Code:

Set objWorksheet1 = objWorkbook.Worksheets(2)
objWorksheet1.Cells(3,2) = "Oak"
Window("BM_269.xlsm").Dialog("Microsoft Excel").WinButton("OK").Click

The dialog box has focus but QTP is unable to click on the OK button. It doesn’t know the dialog exists. After I click OK manually everything runs fine.

Any suggestions?

Thanks,
Raj

[jsknight1969]

the object in the repository is not unique enough to be identified, so you either need to add a unique property value like text to the object or use DP to identify it like this

Code:

Window("BM_269.xlsm").Dialog("Microsoft Excel").WinButton("text:=OK").Click

That should do it.

[Raj20091]

Thanks for the response. The button is unique, that is the only button in the entire script. I think there is something happening with the macros, that is preventing QTP to get control.

[jsknight1969]

If the Object Repsitory can "find the object" correctly, then I agree there is another reason. Can't imagine a Macro interfering with QTP clicking a button, but anything is possible.

[basanth27]

Raj -
Check this Post it helps you.

Let us know the outcome.

[Raj20091]

Thanks for the suggestion. That is a good approch.
That did not work for me. I will have to check with the developer to find out whats happening behind the scene.

[berula]

Hi Raj,
there are two ways:

First use Descriptive Progarmming to select the Dialog.
Or go to object repository an delete the test object details with name "is owned window" and "is child window" for the dialog.

ralf