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?
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?