Show object in MS Excel VBO
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-04-17 12:40 PM
The function of Show object in the MS Excel VBO is to bring in front the excel which is opened. But, instead it blinks in the background. However it works on some machines correctly. What is to be done in this case?
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-04-17 02:26 PM
Have you checked that you always create an instance (action) before you try to show?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-04-17 01:03 PM
Yes
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-05-17 05:00 PM
I've encountered the same thing - has anyone been able to figure it out?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-05-17 09:01 PM
All show does is stop the excel instance from being in a hidden mode. It is not an activate window action.
If for some reason you want to activate the window of a running excel instance (maybe for a demo), maybe create a windows object for excel that attaches to the window (which is showing rather than hidden) and uses the Activate Window action in a navigate stage.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-06-17 07:02 PM
I observed the issue in windows 10 and solve it by launching an excel via Utility - Environment.Start Process action and then attaching. Application Name should be your excel file path and name. Let me know if it works for you.
