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

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


"Wayne Blosat" wrote:

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