Vb Script To Query An Excel Spreadsheet Follow
Here’s what we’d like to have happen. The user, at a prompt, enters a unique code number in a text object. In the database, an Excel spreadsheet, there is a list in column A of many code numbers and in the adjacent cell in column B there is a name associated with each unique code
number. The script needs to query the code number and place the associated name into a second text object. In another similar situation, outside of
Bartender, we have a script, =VLOOKUP(Sheet1!A2,Sheet1!A:B,2,FALSE)” that does this operation. We’re pretty well versed in working with text objects but have never done any type of this programming in Bartender. Will this VLOOKUP function work and could you suggest how we use the database wizard to set this up? Hope what we’re trying to accomplish is clear and thanks in advance for your interest and help. Michael.
Please sign in to leave a comment.