Save as PDF with file name set to date and time it was saved

[OillyBob55]

Good Afternoon all

I have the following code that will save my active sheet as a PDF and name that file Test but what i really want is to save the file as the date and time it was saved. I need it to save sheet8 really not the Active sheet as i cant guarantee sheet8 will be active.

Please Login or Register  to view this content.

[DarkF1ame]

OillyBob55,

One easy way to do this would be by using the "Text" and "Now" functions.

Please Login or Register  to view this content.

[shg]

If the codename for the sheet is Sheet8,

Please Login or Register  to view this content.

If the name is Sheet8, change Sheet8 to Worksheets("Sheet8")

[shg]

@DarkF1ame: You can't have a colon in a filename.

[DarkF1ame]

@shg

Good to know. Whoops. Your solution was infinitely more elegant anyway.

[bakerman2]

FYI the extension .pdf is automatically added when exporting so it's not necessary to add it when composing the filename.

[OillyBob55]

Thanks Shg works perfectly.

[shg]

You're welcome.