Select Excel Sheet For Data At Print Time.

Legacy Poster

• January 27, 2015 18:04

I have multiple excel files saved with data for labels that need to be printed.  They all have the same file name and layout, just saved to different locations.  I don't want to create a separate bartender file for each one.  Is there a way, using coding, to have bartender prompt for the file to use as the database when the user goes to print so I can have just one bartender file, the template.

 

Thanks

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 28, 2015 00:24

  Hi, unfortunately there's no way to externally specify Excel (OLEDB/ODBC) database file from SDK / command line.

  If filename, table name and columns are the same, I would overwrite the excel file before print.

   

  For text database like CSV file, you can switch database file by /D="<database file path>" command line option (used in Commander) or by SDK / XML Script.

  0

Please sign in to leave a comment.