topic Re: Excel - Sensitivity Label in Product Forum

Excel - Sensitivity Label

DipinDevP — Mon, 28 Oct 2024 04:06:22 GMT

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

Re: Excel - Sensitivity Label

michaeloneil — Mon, 28 Oct 2024 09:12:38 GMT

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.

Re: Excel - Sensitivity Label

Neel1 — Tue, 29 Oct 2024 05:28:04 GMT

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

Re: Excel - Sensitivity Label

Michael_S — Wed, 30 Oct 2024 10:47:39 GMT

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

Re: Excel - Sensitivity Label

DipinDevP — Wed, 30 Oct 2024 11:17:26 GMT

@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

Re: Excel - Sensitivity Label

Neel1 — Wed, 30 Oct 2024 12:10:09 GMT

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

Re: Excel - Sensitivity Label

Dilshad_Khan_HCL — Thu, 09 Apr 2026 17:55:17 GMT

Hello,

I am also facing the same error, unable to handle sensitivity pop up. How to handle it . The given screenshot can you please explain the fields to enter like what is the label ID.