跳到主内容

搜索

搜索

List Box Selection To Populate Multiple Substrings Values From Excel File

评论

5 条评论

  • Avatar
    Shotaro Ito

    One simple solution is create database connection to the excel sheet,

    Then use record selection dialog to select a record.

    Record selection dialog is rather like listbox than dropdown, though.

     

    Database connection

    http://www.seagullscientific.com/label-software/training-video-(reading-data-from-database).aspx

     

    Record selection dialog

    http://www.seagullscientific.com/label-software/training-video-(data-entry-at-print-time).aspx

     

     

    Another solution is get dropdown source from excel

    http://forums.seagullscientific.com/index.php?/topic/595-vb-script-dropdown-list-excel/

     

    Use Tab to separate display text and values connected by custom delimiter - something like

    ---

    "ITEM1" & vbTab & "PRODCODE" & "|" & "PRODCODEcc" & "|" & "PRODCODEg" &vbCr

    ---

    on each barcode, use search and transform to chop off unnecessary part - like,

    for SKU1, search | and delete after that, then delete | .

     

    but this is a bit tedious approach compare to just use Database.

    0
  • Avatar
    Shotaro Ito

    viewing attached document, it looks you've already used record selection dialog already - so, the 2nd approach might helps.

    However Search and replace is available from BarTender 10.0. prior to that you need to apply transform by More option's VB Script.

    0
  • Avatar
    Legacy Poster

    Shotaro,
     
    Thank you for the suggestions.  I think in the meantime I need to tackle this in a different way if you could help me out with these two options.
     
    Option 1:   I would like to setup the printing prompt so the product code values can be entered via text box for each of the three barcodes.    I am able to set this up for two of the barcodes but when I try to do it for the third it does not give me the option to create a new prompt.  Not sure what is happening here?  
     
    Option 2:  Another option I would like to explore is batch generating  multiple label files based on this template.  I would like to use an excel  spreadsheet containing a row with three columns listing the product codes.   The three product code values would be pulled from an excel sheet and an individual  bartender label file would be generated for each row in the excel sheet.

    0
  • Avatar
    Legacy Poster

    Shotaro,

     

    Any chance to look at this?   I have a lot of labels I need to generate of you could help me with option 2 that would be greatly appreciated! 

    0
  • Avatar
    Shotaro Ito

    Shotaro,

     

    Any chance to look at this?   I have a lot of labels I need to generate of you could help me with option 2 that would be greatly appreciated! 

    Hi Roger, beg your pardon I had been a bit occupied. For option 2, I recon that's basic usage of database connection, try this video.

    Database connection

    http://www.seagullsc...-database).aspx

    0

请先登录再写评论。