To print the label, the user minimizes Excel, clicks on the label. After selecting it, the appropriate fields are copied to an auxiliary worksheet, which is the one the label links to in order to retrieve the data to be printed (this is required because the option being used is to print all records in the worksheet, as opposed to selecting them one by one). I have created a macro driven Excel sheet that allows the user to select the item to be printed. The printing is performed by issuing the print commands from within the label menu. The labels are created linking fields to an Excel database. After a label is created, the file is saved as a file extension. The labels were created using the Zebra Pro Label software. We use serial number labels printed by Zebra Thermal Transfer Printers. This is a tough one, rather special situation.
0 Comments
Leave a Reply. |