Get formula of a cell and update it

[Mahdi Yaici]

I am currently working with BluePrism V6.9 and i am trying to get the formula of a cell and update it



The cell Result = test + Pourcentage
The formula is B2 + C2 and i am trying to edit the formula

 

[Aniteja]

Create a new Action page in your Excel VBO and use the following code:
Inputs: handle, cellReference
Output: formula_putput
Code:
formula_output = GetInstance(handle).Range(cellReference).Formula