"hlukes"
wrote in message
...

I have a macro that prints selected worksheets after some
calculations
are completed. I have it set to print to my PDF print driver from
Adobe. I also have a third party piece of software that let's me
print without intervention on picking the name of the file.
However,
since I can't tell it the name of the file, it chooses the name of
the excel file. Which overwrites each time since it doesn't pick
the
name of the worksheet. So not so helpful. Does anyone know of a
way to have it use the name of the worksheet instead (or to append
it). I am guessing this isn't something Excel can control and I
need
to find another plug-in but I thought I would check since the
plug-in
is for all programs and not just Excel with its unique features.


Hi,

Most PDF print drivers have an option to automatically name the files.

I use PDFCreator, and it can name files thus:

YYYYMMDDHHMMSSSS.pdf

Where SSSS is seconds and hundredths of a second.

PDFCreator is free so anything you pay more than $10 for should at
least have that option and probably much more flexibility in creating
automatic names.

HTH,

Alan.