Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel workbook showing but not activating

james_crenan
Level 2

‎11-08-16 07:13 PM

Hi All, I'm using Excel to collate data that has validation built into a Macro. Upon opening the workbook and using the show action the workbook is opening and visible on the toolbar for Windows, however it isn't activating to the front of the screen. When using a send keys shortcut to activate the Macro it doesn't run the macro as the workbook isn't activated. Is there a way to activate the workbook so it comes to the front? Thanks James
0 Likes
8 REPLIES 8

PrasenjitMajumd
Level 2

‎11-08-16 08:48 PM

Hello James, Have you tried using MS EXCEL VBO and then using its Action ""SHOW"" after opening the same workbook? It should show the workbook in front. Thanks.
0 Likes

james_crenan
Level 2

‎19-08-16 04:34 PM

Hi, Yeah the show action is the first thing after open the workbook in the flow. It starts flashing on the toolbar but not coming to the front of the screen.
0 Likes

JoachimGeelen
Level 3

‎09-09-16 01:14 PM

Hi, we are experiencing the same problem. Does anyone know a solution?
0 Likes

RadoslavHiko
Level 4

‎09-09-16 07:06 PM

To run a macro I would go for the Run Macro action available in the MS Excel VBO. If you really need to bring Excel to the front, I would create a new Windows object that would attach Excel, spy the Excel window and use the Activate action of the Navigate stage to bring it to the front.
0 Likes

CarsonLiu
Level 2
In response to RadoslavHiko

‎19-09-16 08:59 AM

hi Radoslav, could I know how to spy an Excel window? thanks.
0 Likes

ShreyansNahar
Level 5

‎19-09-16 12:52 PM

Hi Liu, You can use the application modeler to model Excel as an application in a new object. Post that, identify the window and use it to activate Excel.
0 Likes

RadoslavHiko
Level 4

‎19-09-16 02:52 PM

As Shreyans is pointing out, all you need to do is to create a new Windows based application object in BP and then spy Excel using the Win mode.
0 Likes

Jothin.Georgi
Level 2
In response to RadoslavHiko

‎22-12-23 04:06 AM

Hello All,

I faced a similar activation issue when trying to capture an Excel screenshot. Instead of resorting to spying, you can employ an alternative solution. The trick here is to open another sample workbook using the 'Open Workbook' action and then use the 'Show' action. This will bring both workbooks to the forefront. After completing this step, you can proceed to close the sample workbook.


------------------------------