Macro Failed to Run through Control Room

[KodiSrihari]

Hi All,

I have process that needs to Run Macro to process some steps , it's getting Exceptions in run macro stage as  during running the process from control room.

But while running the process in debug mode it is working fine.

Any suggestions on the above issue so that it can run the macro smoothly through control room.

Thanks ,
Srihari

------------------------------
Srihari
RPA Developer
------------------------------

[michaeloneil]

Hi Srihari

Can you give us information on the exceptions you are getting when running this in control room? E.g. exception type/detail/message

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[KodiSrihari]

Hi Michael ,

It has to Press the Button in Excel to run the Automation , where Getting Exception as Macro Failed to Run.

But in debug mode if we press button in excel it is working fine.

Thanks,
Srihari

------------------------------
Srihari
RPA Developer
------------------------------

[michaeloneil]

Hi @KodiSrihari

I would suggest not using surface automation for excel and instead using direct interaction using the excel out the box functionality in blue prism. In this case if you want to initiate a macro then you can use the MS Excel - Extended VBO and use the action Run Macro. You just need to then give the handle and the macro name the button is initiating and your bot can run it without using the button in excel. Alternatively if you are familiar with macros you could review the code and build your bot to do the same actions as the macro is doing.​

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------