https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76350#M28861 Hi, I am trying to search for values in excel. I cannot find that functionality in the Excel VBO, and currently elaborate with sending keys (ctrl+f). Anyone with other suggestions? Br, Maria Wed, 11 May 2016 17:16:00 GMT MariaKihlberg 2016-05-11T17:16:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76350#M28861 Hi, I am trying to search for values in excel. I cannot find that functionality in the Excel VBO, and currently elaborate with sending keys (ctrl+f). Anyone with other suggestions? Br, Maria Wed, 11 May 2016 17:16:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76350#M28861 MariaKihlberg 2016-05-11T17:16:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76351#M28862 Hi Maria, What is it that you are trying to do once you have found these values? Depending on what the end goal is with the information, will allow a more tailored solution. Many Thanks, James Wed, 11 May 2016 18:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76351#M28862 jgreaves2 2016-05-11T18:33:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76352#M28863 Hi Maria, find attached action you can copy into the MS Excel VBO that performs the search and returns cell reference in which value has been found. Fri, 13 May 2016 12:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76352#M28863 ArchiveUser 2016-05-13T12:38:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76353#M28864 Hi all, Thanks for your comments - I will test and see which one that works best for the process. Basically my objective is to decide whether or not the value that I search for exists. If it does not exist, I will send a business exception. Br, Maria Fri, 13 May 2016 18:42:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76353#M28864 MariaKihlberg 2016-05-13T18:42:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76354#M28865 Hi, I can't see any attachment, but I am after a similar functionality if you could help please. Mon, 14 Aug 2017 10:11:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76354#M28865 NikitaKabra 2017-08-14T10:11:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76355#M28866 Create a new action with following code: Dim wb As Object wb = GetWorkbook(Handle, Workbook) wb.activesheet.Cells.Find(What:=SearchValue).Activate Having handle, workbook and searchvalue as inputs of your code stage. The code stage will throw exception which you will have to catch in case the search value is not found. Mon, 14 Aug 2017 13:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76355#M28866 SébastienBulté 2017-08-14T13:09:00Z https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76356#M28867 Hi nikita.kabra, Please use the option peterlacken suggested earlier. 1. Get the output to a collection from Excel. 2. Use ""Utility - Collection Manipulation"" VBO, and ""Collection Contains Value"" in Action. 3. Pass the Column Name and Value to search. Output will be true/false. Thu, 17 Aug 2017 15:03:00 GMT https://community.blueprism.com/t5/Product-Forum/Searching-for-values-in-excel/m-p/76356#M28867 Anonymous 2017-08-17T15:03:00Z