Check if Excel sheet contains forumlas

[KristinaBrend]

Is there any way to check if an Excel sheet contains formulas? How would you do this?

[John__Carter]

I think you'd need to adapt the Excel VBO to make use of the Range.HasFormula property. https://docs.microsoft.com/en-us/office/vba/api/excel.range.hasformula

[TetsujiJunicho]

Hi,

Here's the Extending the MS Excel VBO: https://portal.blueprism.com/system/files/2017-11/Extending%20MS%20Excel%20VBO.PDF

Hope this helps.

------------------------------
Tetsuji Junicho
Manager of RPA Practice Grp.
Accenture Japan
Asia/Tokyo
------------------------------