Discussion Locked

How to add an string to spool job name

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by abarnes70

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

This discussion is closed to new replies.