Issue with with Start process while opening an Excel file(kind of macro)

[Deva393]

Hi Team,

I am trying to open an excel file(macro) through start process stage, but process not reaching end stage (next stage).
Excel macro is opening along with some popup window, until unless closing popup window bot not able to reaching next step.

through launch it is working but i want to make path as dynamic with machine name.

how to solve this issue

 

[Sachin_Kharmale]

Hi Deva,

i am also facing same issue with excel so i have done following steps to solved it.
we need to create new object to Handle excel Pop Up.


1. Create new Object for handling excel file.
2.set application launch path as excel file path which will be dynamic
3.Once excel file is launch from the Object Studio. if it is not attach then attach excel file to Blue prism.
4.Spy the Pop up which will open after ,opening the excel file. also Spy pop up Buttons.
5.Perform required action and do your task.

I Hope it will help you.

Best,
Sachin