Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel Files

Anonymous
Not applicable

‎01-09-16 07:04 PM

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

Ravindersaini
Level 7

‎02-09-16 07:05 PM

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

TomBlackburn1
Level 7

‎03-09-16 01:33 AM

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.
0 Likes

Anonymous
Not applicable
In response to Ravindersaini

‎14-03-17 04:17 AM

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