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