topic hi Radoslav, could I know how in Product Forum

Excel workbook showing but not activating

james_crenan — Thu, 11 Aug 2016 18:13:00 GMT

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

Hello James,

PrasenjitMajumd — Thu, 11 Aug 2016 19:48:00 GMT

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.

Hi, Yeah the show action is

james_crenan — Fri, 19 Aug 2016 15:34:00 GMT

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.

Hi, we are experiencing the

JoachimGeelen — Fri, 09 Sep 2016 12:14:00 GMT

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

To run a macro I would go for

RadoslavHiko — Fri, 09 Sep 2016 18:06:00 GMT

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.

hi Radoslav, could I know how

CarsonLiu — Mon, 19 Sep 2016 07:59:00 GMT

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

Hi Liu,

ShreyansNahar — Mon, 19 Sep 2016 11:52:00 GMT

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.

As Shreyans is pointing out,

RadoslavHiko — Mon, 19 Sep 2016 13:52:00 GMT

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.

RE: As Shreyans is pointing out,

Jothin.Georgi — Fri, 22 Dec 2023 04:06:00 GMT

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.

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