Macro to save as PDF issue

[Justair07]

Hello,

I have created a simple macro to save a selected area as a pdf to my desktop. I want the macro to save the PDF as the current week ending date. Is this possible? I currently enter the date in a cell and then engage the macro. Is it possible to have the macro automatically name the PDF file as the current week ending date?

Here is what i got so far.....

Please help.....

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.