Choose .xls File At Print Time Folgen

0
Avatar
Legacy Poster

I have a VBA macro that creates an .xls spreadsheet each time that it is run.  Each spreadsheet generated by the macro has a Named region of a spreadsheet that I would like to point the Bartender software to.

 

 

Is there a way set up a Bartender .btw file to ask the user which spreadsheet they wish to use at print time?  All of these spreadsheets would have a named region called "Barcodes" that would have the data that needs to go onto the labels.  I've seen the videos on how to set up a database, but it seems that this database setup is designed to have a single database hardcoded to the .btw setup.  I see how you could print only certain records from a database, but is there a way to choose a database at runtime?

 

 

1 Kommentare

0
Avatar
Ian Cummings
Moderator
Aktionen für Kommentare Permalink

It's not possible to define a fixed database connection in BarTender via automation.  You can only do this via a text file.  It sounds like your best bet is to have your VBA macro control BarTender via automation, opening a label to print, setting data on the label, either directly or via a temporary text file, and then printing to s specified printer.  The below white papers should help get you started:

 

http://www.seagullscientific.com/label-software/whitepapers/controlling-barcode-label-software-using-c-sharp-and-vb.net(english).pdf

 

http://www.seagullscientific.com/label-software/whitepapers/controlling-barcode-label-software-using-activex-automation.pdf

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.