topic RE: Running Macro from BP in Product Forum

Running Macro from BP

maneesh.vemula1 — Mon, 23 Sep 2019 21:09:00 GMT

Hi - I am trying to run a macro using MS-Excel VBO. The macro is stored as a personal macro workbook. It is in the format '.XLSB'. When i manually open the file - i am able to run the macro. But when i try to do it through the automation tool - I am getting an error stating that the macro does not exist or has been removed. Please assist.

Thanks in advance.

------------------------------
Maneesh Vemula

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

RE: Running Macro from BP

IshanMahajan — Tue, 24 Sep 2019 07:16:00 GMT

Running Excel Macro might be painful sometimes, what i do is, Open the workbook by excel VBO and activate it, i have created a custom object which attaches to Excel window, i use the Send Keys to run macro(you will have to define the keyboard shortcuts for your macro) and i put a MsgBox line in last of macro code so BluePrism can identify that the Macro execution has been completed, this will also help you in not getting into infinite loop, which may occur with Excel VBO, Run Macro action.

I think there is one more excel VBO available which allows to run the macro with a parallel thread but it not part of standard installation and you may have to reach out to your Blue Prism Administrator to get that.

Hope this will help.

------------------------------
Ishan Mahajan
India
------------------------------

RE: Running Macro from BP

YassineLamarti — Tue, 01 Oct 2019 15:32:00 GMT

Hello Maneesh,

I had the same issue, but finally I found how to resolve it in internet.

You can't use the action "Run Macro" in an excel with extention ".XLSB". but if you are using the extention "XLSM", be sure that will works.

I hope that I helped you by my suggestion.

Regards,

------------------------------
Yassine Lamarti
Blue prism designer
Accenture
Africa/Casablanca
------------------------------

RE: Running Macro from BP

KULRANJANSINGH1 — Wed, 18 Dec 2019 08:05:00 GMT

Hi Yassine,

Can you please elaborate how to do that, basically I want to run a macro through a file to multiple different files. I have seen run macro action but unable to work it out.

------------------------------
KULRANJAN SINGH NEGI
Associate Professional Programmer Analyst
DXC Technology
Asia/Kolkata
------------------------------

RE: Running Macro from BP

Vamshi_KrishnaD — Fri, 17 Jan 2020 14:53:00 GMT

Hi

create a fresh excel file with extension .xlsm and write your macro code to deal with mutlple files

------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------

RE: Running Macro from BP

AmiBarrett — Fri, 17 Jan 2020 17:22:00 GMT

If the macro doesn't change (and you have access to its source), you can theoretically add it in as a new action in the Excel VBO. I've had to do this for some other projects, but it technically goes against best-practice since any other process loading the VBO will also load this action into memory. If this is a concern for you, you could save a separate copy of the Excel VBO off and modify that one.

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Richardson, TX
------------------------------

RE: Running Macro from BP

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

Hi Mate,

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: Running Macro from BP

jessMadsen — Thu, 20 Oct 2022 15:17:00 GMT

Hej Ishan
Har du mulig for at sende din kode til mig
Vh.

------------------------------
jess Madsen
------------------------------

RE: Running Macro from BP

ewilson — Thu, 20 Oct 2022 20:09:00 GMT

@jess Madsen,

The Excel VBO on the Digital Exchange includes the action Ishan had referred to about running a macro with a parallel thread that checks for pop-ups (ex. error messages) and dismisses them. You can find the VBO here.

Cheers,

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