topic Check if Excel sheet contains forumlas in Product Forum

Check if Excel sheet contains forumlas

KristinaBrend — Thu, 09 May 2019 12:44:00 GMT

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

John__Carter — Thu, 09 May 2019 14:44:00 GMT

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

tjunicho — Wed, 17 Jul 2019 12:30:00 GMT

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
------------------------------