topic Excel Find Value macro in Product Forum

Excel Find Value macro

jpunthambaker — Tue, 28 Jun 2016 03:23:00 GMT

Hi, I'm attempting to build a solution that involves searching for a specific value in a large excel sheet. Would anybody have any advice on how to do this via a macro / code stage? Iterating through lines takes an excessive amount of time. Thanks

If simple SQL like queries

Deep.Shah — Tue, 28 Jun 2016 12:11:00 GMT

If simple SQL like queries can help you find what you are trying to search in an Excel, try querying with the help of OLEDB Object.

Try to check my answer here:

ArchiveUser — Tue, 28 Jun 2016 15:30:00 GMT

Try to check my answer here: https://portal.blueprism.com/excel-issue-need-find-cell-value I have posted a code there

Radoslav, Deep - many many

jpunthambaker — Tue, 28 Jun 2016 17:50:00 GMT

Radoslav, Deep - many many thanks for your replies - much appreciated. Regards