Excel - Sensitivity Label

[DipinDevP]

Hi Experts,

Please help me on below query!

While I am trying to Save data after copying it from one Excel file to another (newly created) using MS Excel VBO actions, below popup comes.

Is there any option to handle this (to set a label or cancel it) without implementing UI automation?

Thanks,

Dipin Dev P

[michaeloneil · Accepted solution]

Hi @DipinDevP 

I think you could add in a code stage to disable alerts which should hopefully resolve this. I've done this previously to prevent unwanted pop ups and it worked but it wont necessarily work with every pop up. Open the action "Open Workbook" in the excel object and add in a new code stage and open this stage, for the inputs include handle then for the code add in "GetInstance(handle).Application.DisplayAlerts = false"

You can make the alerts optional if you want by adding an input and changing 'false' to the name of the input e.g. GetInstance(handle).Application.DisplayAlerts = alerts_enabled

This would allow you to set it to either true or false depending on your needs. I tend to have this just as false because i generally dont want any alerts/pop ups getting in the way of my processes.

Hope this helps.

[Neel1 · Accepted solution]

Hello @DipinDevP - Latest Excel VBO has the feature to Get and Set the Sensitivity label. Features are added two week back.check if this is solving the issue for you.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

[Michael_S]

@DipinDevP - how are you getting on? Did the latest Excel VBO that @Neel1 linked to help?

[DipinDevP]

@Neel1 @Michael_S 

Sorry for the late response! Thanks for the suggestions.

Can anyone tell how can I set a Sensitivity Label from below list? Where I should put RESTRICTED in the action parameters? 

Thanks,

Dipin Dev P

[Neel1]

hello @DipinDevP - can you try getting it from Get action.