Hi All,
I am using Access 2013 with Windows 8.1.
I have a Zebra 505 label printer installed and it is working properly. I can print to it from Word or NotePad etc.
Ultimately, I will be trying to send a file (FedEx.zpl) to the printer from VBA. The file is a response from the FedEx Ship Services Shipment routine and is the label format that the Zebra recognizes.
But first, I am try to get something (anything) to print from the printer in code directly.
I have tried numerous methods with no luck.
I wrote a piece of code to enumerate through the all the installed printers and it does indeed find ZebraZP on port USB001.
I have tried different snippets of code to try and get it to work with no luck.
I don't get errors, but nothing happens. Below is just a simple example where I am just trying to get something to print.
You will see from some of the code commented out, where I have tried different things with no luck.
Dim ItemName, ItemNum, ClassID
ItemName = "Expresso"
ItemNum = 142222
ClassID = "Coffee"
'Open "\\IraDellLaptop\ZebraZP" For Output As #1 'try to print to it using network name, no luck
Open "USB1" For Output As #1
Print #1, ItemName & " " & ItemNum & " " & ClassID 'try some random text, no luck
Print #1, "C:\Users\ISaunders\Documents\Quality Chemical\RateResponse.txt" 'try a text file, no luck
Close #1
Any help would be greatly appreciated.
Thanks,
Ira