topic Creating Pivot in existing excel in Product Forum

Creating Pivot in existing excel

SAINNATHSURAY — Mon, 28 Mar 2022 08:18:00 GMT

Hi Everyone,

I have a process where I need to open excel , the pivot is already created , only we need to change the reference range and refresh the sheet , how can we trigger this from blue prism

if we create Macro recording and run the Macro from blueprism does this work ? but the excel files are dynamic

------------------------------
SAINNATH SURAY
Business process Lead
TATA CONSULTANCY SERVICE
Asia/Kolkata
------------------------------

RE: Creating Pivot in existing excel

PvD_SE — Mon, 28 Mar 2022 10:27:00 GMT

Hi S,

While I do not have an answer to your question, I would suggest to create new threads like this one, opposite to reopening older threads with similar content.

Thanks in advance.

------------------------------
Happy coding!
Paul
Sweden
------------------------------

RE: Creating Pivot in existing excel

SAINNATHSURAY — Tue, 29 Mar 2022 04:00:00 GMT

Sure Paul

------------------------------
SAINNATH SURAY
Business process Lead
TATA CONSULTANCY SERVICE
Asia/Kolkata
------------------------------

RE: Creating Pivot in existing excel

ewilson — Tue, 29 Mar 2022 14:26:00 GMT

@SAINNATHSURAY,

Have you looked at the latest version of the MS Excel VBO - Extended? It includes pivot table actions including an action named Amend Pivot Table Data Source. I believe this may be what you're looking for as it allows you to change the Range.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Creating Pivot in existing excel

SAINNATHSURAY — Wed, 30 Mar 2022 18:37:00 GMT

Hi Eric ,

Surely will check that , can you help me on below point also

the excel files are dynamic to refresh pivot , if we create Macro recording and run the Macro from blueprism does this work. if yes how to run the macro dynamically .

Thanks,
Sainath.

------------------------------
SAINNATH SURAY
Business process Lead
TATA CONSULTANCY SERVICE
Asia/Kolkata
------------------------------

RE: Creating Pivot in existing excel

ewilson — Wed, 30 Mar 2022 18:54:00 GMT

@SAINNATHSURAY,

There are two different actions available on the latest Excel VBO that can be used for running macros within an Excel: Run Macro and Run Macro with Parallel Thread. The first is used for simply executing a macro that resides within the Workbook. The second can be used to execute a macro that includes a pop-up prompt of the user. In the past this situation would cause Blue Prism to be stuck waiting for someone to dismiss the dialog. With this action, the dialog will be dismissed programmatically allowing Blue Prism to continue onward.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------