Printing Zebra labels from Excel

[ChuckDrago]

This is a tough one, rather special situation.
We use serial number labels printed by Zebra Thermal Transfer Printers. The labels were created using the Zebra Pro Label software. After a label is created, the file is saved as a file extension .lbl. The labels are created linking fields to an Excel database. The printing is performed by issuing the print commands from within the label menu.

I have created a macro driven Excel sheet that allows the user to select the item to be printed. 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). To print the label, the user minimizes Excel, clicks on the label .lbl file and clicks on Print.

Is there any way for me to open the label file using a Shell command? I suppose issuing from Excel the print command to the label is not possible, but if I can just display the label to allow the user to select print and qty of copies that would be great.

Thanks everyone!
Chuck

 

[ranman256]

sFilepath = "c:\program files\myapp.exe"
call shell(sFilepath)