Excel Files

[Anonymous]

Hi, How do I work with excel files to do Vlookup, open file, and copying data? Regards, Reuben Kekana

[Ravindersaini]

Hi, Kindly make use of the utility ""MS Excel VBO"" object.It will help in doing all the operations with Excel.

[TomBlackburn1]

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.

[Anonymous]

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