https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54862#M9282 Hi, How do I work with excel files to do Vlookup, open file, and copying data? Regards, Reuben Kekana Thu, 01 Sep 2016 18:04:00 GMT Anonymous 2016-09-01T18:04:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54862#M9282 Hi, How do I work with excel files to do Vlookup, open file, and copying data? Regards, Reuben Kekana Thu, 01 Sep 2016 18:04:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54862#M9282 Anonymous 2016-09-01T18:04:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54863#M9283 Hi, Kindly make use of the utility ""MS Excel VBO"" object.It will help in doing all the operations with Excel. Fri, 02 Sep 2016 18:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54863#M9283 Ravindersaini 2016-09-02T18:05:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54864#M9284 If your spreadsheet has a lot of VLOOKUP functions, it may be worth looking to extend your VBO, or duplicate your Excel VBO to contain an action to toggle calculations on and off and perform ADHOC calculation requests. I had to do this for one of our customers as each time a change was made, the calculation events kicked in and froze the spreadsheet. Sat, 03 Sep 2016 00:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54864#M9284 TomBlackburn1 2016-09-03T00:33:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54865#M9285 Hi, I have looked at the list of functions in Excel VBO and did not find anything relating to ""Lookup"". Do you think this is something that needs to be manually coded or can you please suggest a function that can be used to complete vlookup. I tried to find a function closer to vlookup that I can tweak little bit to achieve this to no much success. Any help will be much appreciated. Thanks, Sai Rakesh Tue, 14 Mar 2017 04:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Files/m-p/54865#M9285 Anonymous 2017-03-14T04:17:00Z