I have a workbook that I use daily to send pricing to various customers.
The first sheet is the data entry which flows into all following
sheets and combines with existing formulas to create personalized
pricing for each customer. I then turn each worksheet of this workbook
into a PDF document to email to each customer. I am new to the world
of macros and I have surprisingly managed to create a macro that
somewhat automates the creation of the PDF's. My only downfall is that
it "pauses" inbetween each sheet because it needs me to go to the
correct directory, click on the PDF name to create it and click save.
Each day I create the new PDF's over the existing PDF's. Because the
PDF names stay constant from day to day, is there a way I can program
that into the macro(s) so it will do that part for me? I hope I
explained this well enough. Any help would be greatly appreciated!

Thanks,
Michelle



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/