How to spy a Excel form button and message box?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-09-16 08:26 AM
I write a macro in the Excel, which will pop up a form to show serious buttons to let BP to click, but I can't spy the buttons on the form? anyone knows how?
meanwhile, when the macro is done, there's another pop up of a message box to notice the user that macro is done. how to spy this message box?
thanks.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-09-16 05:29 PM
Active Accessibility worked for me. What did you try?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-16 10:57 AM
We are also facing the same issue. The button is not getting identified in any mode and entire excel is only getting identified. The file extn is xlsb .
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-16 05:25 PM
Is your Excel locally installed? It may be virtualized and that is why you can only spy the whole application window.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-17 05:56 PM
Facing similar kind of issue if someone can help me: I am unable to spy a cell in excel using region mode i.e
surface automation
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-03-17 03:09 AM
Same here, I can't identify the button, any suggestion? Excel is installed locally.
