Change access Version 7 (Net)

Action group: Excel 

Description

Changes access to an Excel document

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Limit accessBoolean variable. If the parameter value is True, the document will be denied sharing. If the parameter is False, then the action saves the document with the current name and share. The default is false.Robin.BooleantrueNo

Special conditions of use

None.

Example of use 

Task

There is an Excel document. It is required to restrict access to this document to other users.

Solution

Use the "Open", "Change access", "Save" actions. 

Implementation

  1. Open the "Excel" action group.
  2. Open the "General" subgroup.
  3. Move the "Open" action in the studio workspace. 


  4. Move the "Change access" action in the studio workspace 


  5. Move the "Save" action in the studio workspace 


  6. Change user.
  7. Open a new document.

Result

The program robot completed successfully. 


After changing the user and further opening the file - access to the file is restricted.