Printing Labels on Zebra Printer

Hi,

I have a spreadsheet that has a UserForm and that has a button called "Print Label".

To make that button work I have written the following code:

Please Login or Register  to view this content.

When I click on the button, the information on the Label tab gets printed to a normal network printer if I forget to switch it to the zebra label printer.
I have done a lot of searching and can not find a solution.

Information about the label printer:
Printer Name: MSP-Label2
Printer Network: MSP-Label2 on MPS-DC-001

Picture attached

Thanks!

Try modding the code with this on the second to last line:

Please Login or Register  to view this content.

Pete

Please Login or Register  to view this content.

Compile error: Invalid or unqualified reference

Please Login or Register  to view this content.

Prints on default network printer.

I have tried to use the following websites for help, but I could not get it to work.
https://stackoverflow.com/questions/...ocket-printing
http://www.vbforums.com/showthread.p...pl-code-SOLVED!!

You need to get this part working before moving onto more complex tasks.

No point in being able to print the labels automatically if you can't print them in the right place.

See if this works, the idea was right, but there was a typo in the printer name from Pete's post (msp nstead of mps), so it would not have been found.

Please Login or Register  to view this content.

I took it from the OP. (I didn't catch that the post didn't match the properties in the printer dialogue box.)
Live and learn.
Pete

Easily missed, Pete!

I was comparing the code to the properties, looking for extra / missing spaces, etc. I went over it 3 times before noticing the error.

If I had been replying to this initially, I would have done the same as you and copied the name from the information given by the OP as opposed to retyping it from the image.

I compared your reply to the code in post #3 and could see no difference so then I compared yours to the image, solely because both fit on the screen together without scrolling up and down, if I had looked at the text above the image instead and compared that to your reply then I might not have noticed the typo.

Sorry but none of this worked.
Here is what I have tried:

Please Login or Register  to view this content.

This brings up a box where I can select the printer, and that name is in a different formatMicrosoft_Excel_Production_Tags.jpg

Using advise from https://www.mrexcel.com/forum/excel-...ter-macro.html
that brings up: Microsoft_Excel_Production_Tags 2.jpg

The location of the printer has moved since the original post, so that needs to be taken into consideration.

Will dig around and see what I can find out.

Excellent catch. However, that did not work. After messing with this for a few hours I eventually got it to work!

Here is the final code:

Please Login or Register  to view this content.

Reputation added to everyone who contributed, post labeled as solved.

Thanks, everyone for the input!

Now on to the next issue: https://www.excelforum.com/excel-pro...ml#post4963796