Saving a worksheet with changing month and year

[GroveMike600]

How do I save a worksheet in PDF format that includes a changeable month and year, for example: Filename:= "C:\Desktop\Name Jun 2014.pdf"

[mehmetcik]

Use the following code in a macro

Please Login or Register  to view this content.

[GroveMike600]

Thanks, but I get a runtime error when I use the code you sent. Here's the code from my macro. I'd like to add the month and year after the word Report, and if it helps, I've got that info in a cell in the workbook in the format mmm yyyy. What I have, up to this point, works fine; it's just adding the date that's a problem.

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\Flanigan Family\Desktop\EG Library Activity Report - .pdf", Quality _
:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True

[Vikas_Gautam]

Try this.. for date

Please Login or Register  to view this content.

Say thanks, click *

[GroveMike600]

That worked--thanks.