Vb Script To Query An Excel Spreadsheet Follow

0
Avatar
Legacy Poster

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.

2 comments

0
Avatar
Legacy Poster
Comment actions Permalink

VLOOKUP is an Excel function - you cannot use this with VBS or BarTender.

It seems the easiest solution for you is, as you suggested, to use the Database Wizard within BarTender. Try it - it should not bee too difficult. Once the connection is set up, you can create a Query Prompt. This is where the user later on will enter the unique code number at print time. Make sure you configure that Query Prompt as a selection criteria in the database setup dialog.

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks, this information is helpful.

Please sign in to leave a comment.