Web Development

General discussion


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.

Juan Belmonte

This conversation is currently closed to new comments.

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.


Related Discussions

Related Forums