Trying to modify a vba TempFileName line

[hatstand]

Hi,

I’m trying to modify this line:


TempFileName = "Weekly " & Sourcewb.Name & " " & Format(Now, "dd-mmm-yy h-mm-ss")

To that the date is 14 days a head of today. Is there anyway to alter this line to add an extra 14 days?

 

[nirvana_]

Try this.

TempFileName = "Weekly " & Sourcewb.Name & " " & Format(DateAdd("d", 14, Now()), "dd-mmm-yy h-mm-ss")