How to fetch formula of a cell using blue prism

[syed]

Hi,

How I can get the formula of a particular cell in excel.

 

[VJR]

Hi,

How I can get the formula of a particular cell in excel.

syed,

Make a copy of the 'Get Cell Value' action of the Excel VBO and in the new copy make the modifications as below

Dim cellVal as String = GetInstance(handle).ActiveCell.Value
Dim cellVal as String = GetInstance(handle).ActiveCell.Formula

 

[subhash]

Hi VJR,
I tried the above code but it is not working. Could you please check.

Regards,

 

[subhash]

ERROR:
View attachment 1585923906450.png

 

[GatesV]

Not sure what went wrong with subhash, but this is working perfectly on my side of things.

Thanks @ VJR.