I have a spreadsheet where I am trying to print barcode labels. The barcode is found in cell A1. I have looked in a lot of places and I can't really figure out exactly how to do it. This is the code that I have so far but it gives me an error. The printer name should be right. Any suggestions on how to fix it? Some of this code I just copied from another thread.
Please Login or Register to view this content.
Last edited by manofcheese; 06-05-2014 at 10:03 AM.
The macro recorder puts a colon after the selected printer name, so maybe:
Please Login or Register to view this content.
Ben Van Johnson
Hmmm.... No dice. It says that there is no object for the sixth line of code. Do I need to turn on a reference for my printer somewhere?
I played with it a little and it works great now.Here is the code I used.
Please Login or Register to view this content.
Glad you figured it out
1. Include a sample workbook with an example of the result you want
2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks