WHY EXCEL APPLICATION SCOPE SOMETIMES GIVES SAVE YES OR NO POP UP?

Help Studio
, ,
1

Hi All,

I just need small help , whenever BOT is running sometimes due to the Excel Application Scope , Save Yes No Pop up is coming and my Bot gets on hold there due to this pop up. I used save workbook activity also but that doesnt work. How to resolve this any idea ?

Regards,
Ritesh

1 Like
2

Hi,

Can you try to use ExcelProcessScope and UseExcelFile activity?
We can turn off display alert in ExcelProcess activity.

image
image1369×797 44.6 KB

Note: Any excel activities inside ExcelApplicationScope can be also used inside UseExcelFile.

Regards,

3

Hi Thanks for the solution but it is modifying the Excel Date time creation which is creating issue as there is a file based trigger enabled for this, whenver there is a change of Date Time of the file , bot will be trigered automatically.

4

And just checked right now , its Excel Process scope also opening the same sve yes or no pop up sometimes even after making the properties as False there.

5

You can disable this property from excel as well if you using a template file, in classic design you can use excel application scope n see if that works

6

unchecked and made everything as Not visible , save changes everything. Still Save yes no pop up coming

7

Why not just use Check App State to see if the popup appears, and then click Yes or No depending upon your needs?

1 Like
8

Does your excel contain formulas / macros that include the sysdate/now/today like functionalities?

If so the save popup might get thrown because the timestam read from the sysdate continiously updates, hence excel might see that as a data update and thus prompt for save changes?

Maybe far fetched… so just a thought…

1 Like