I am currently using excel to print on demand labels that are run through a cutter that cuts the labels at the end of a print job. The issue is that I need to add a blank copy at the end of the print job to give room between the printer output and cutter. Below is my current code. One issue is that the quantity of labels that are printed is dependent on the user input and i would need a single blank copy at the end.
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
The printer reads this as a separate print job and cut the label before the added command and cuts again after the added command. Is it possible to set separate "Copies:" number based on an array? I tried something similar to the below, but it didn't work. Didn't know if anyone has tried to do something like this before. If it's not possible I may just try to create a separate macro to enable the cutter on the printer as a separate button to cut on demand.
Thank you for the help!Please Login or Register to view this content.
Maybe:
And, Thanks for the rep!Please Login or Register to view this content.
Last edited by xladept; 07-21-2014 at 07:46 PM.
That sent me on the right track and it's working now! Thank you very much.
Terrific - I was wondering if we shouldn't have added the sheet at the end!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks