Send file to Zebra Printer ZP 505

[Ira]

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

[RuralGuy]

Here's a couple of links that might help:
http://www.granite.ab.ca/access/serialport.htm
http://www.thescarms.com/vbasic/commio.aspx