Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the reply. I reply to the group and directly as I am not sure
whether you would notice replies to "old" posts (at the rate postings are made to this group they age very quickly). I did notice that if I want to print many labels only about maximum 7 or 8 get printed, so I assumed this bit of code was included to handle that. I worked around it by writing all the labels to the text file and then copying the text file to lpt1 once only. This works well enough. The only hitch is that if the printer messes up a label (my printer does that sometimes - I think it is a mechanical fault) and I switch it off, realign the labels and switch on, the printing goes on where it left off - with the alignment most likely out. I would like to have the printer queue cleared if the printer stops or is switched off. Fortunately the printer is behaving well and I print in smaller batches of 20. Laurence "raypayette" wrote in message ... This is old code, probably a QuickBasic legacy! It seems that the printer needed some delay to process the matter. If your printer is recognized by Windows® I strongly suggest that you let Windows handle it. You might need to update the driver by going to the manufacturer's web page. I would rework everything from Excel. -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=553051 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Labels not printing zip codes | Excel Discussion (Misc queries) | |||
Printing labels from excel | Excel Discussion (Misc queries) | |||
my merged address labels are only printing ONE page -- answer? | Excel Discussion (Misc queries) | |||
Printing Labels | Excel Discussion (Misc queries) | |||
Printing a Pivot Table from code - Excel 2003 | Excel Discussion (Misc queries) |