-
Adding the date to the filename
Hi John
With this code, it works great saving selected slides as Save As with the same file name as the original file, but I'm trying to add the date. Assuming the Opened file is called MySlides.pptx
[ORIGINAL PERFECT CODE]
Call NewPPT.SaveAs("C:\MyFolder" & OldPPT.Name)
[/CODE]
However, when I edit this to add the date:
[NEW CODE]
Call NewPPT.SaveAs("C:\MyFolder" & OldPPT.Name & Format(Date, " dd-mm-yy"))
[/CODE]
The filename becomes: MySlides.pptx 19-07-19.pptx
I've tried all sorts to remove the .pptx in the middle of the filename.
Thank you in advance
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules