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

--
hluke
-----------------------------------------------------------------------
hlukes's Profile: http://www.excelforum.com/member.php...fo&userid=2594
View this thread: http://www.excelforum.com/showthread.php?threadid=39318

"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.

Incidentally,
The source code for PDFCreator is available (don't have the link to hand),
but then you could do as you please.

NickHK

"Alan" wrote in message
...
"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.