General discussion

Locked

How to add an string to spool job name

By jbmbhs ·
Hi friends;

I have an excel macro that sends a page to printer basen on data in two cells.

It's okay but when i have an spool of several hundreds of different jobs but all with the same name (all with the name of the worksheet!) it's difficult to stop or pause exact one!

I need to add an small string (likely) at start of the printjob name (or even at the end) to be able to distinguish after close app but before it prints.

Thanks
Juan Belmonte
www.CARTRIX-SLOT.com

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by a.barnes In reply to How to add an string to s ...

Hi Juan

Not sure how to rename a print job, but you could try temporarily renaming the Worksheet before printing, and then have the macro change the name back after printing. For example, assuming the name you want is in cell B2:

strTemp = Range("B2").Value
strWName = ActiveSheet.Name
ActiveSheet.Name = strTemp
...
... Printing commands here
...
ActiveSheet.Name = strWName

Hope that helps.


Andrew

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums