Printing and Document Name

[Wayne Blosat]

I am using the PRINTOUT command to print a worksheet. Is there a way to
change the document name that Windows using in the printers dialog to
something besides the workbook name?


__________________________________________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800

 

[keepitcool]

Wayne, I don't think this can be done without some
getting involved in some tricky API programming.

in case you're interested:
MSDN /Windows GDI/ Printing and Print Spooler.
might give you an idea of complexity, and enough
keywords to give it a try on google.

Else

trap the printout event.
save a copy of the sheets or book under desired name
print that instead
revert to original
kill the copy.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >