Save pdf to specifc year/month folder + manage folders based on CDate

Hello experts,
we have daily 15 savings of files to drive, I would like to have manage of files automatic in background. Please help me with:

A) CREATING FOLDER, automatic saving to correct folder

Could you please help me with code what based on „Curent date“ create folders to d:\Folder\
1) if not existing – current Year – Then
2) if not existing – current Month
and save sheet as pdf in format
Currentdate (YY-MM-DD-hh-mm-ss.pdf

EXAMPLES:
OVERVIEW 20-04-28-13-38-18.pdf
saving to folder below (with creating year+month folder)
d:\Folder\2020\04\

OVERVIEW 20-05-15-13-20-10.pdf
saving to folder below (with creating month folder)
d:\Folder\2020\05\

OVERVIEW 21-01-01-14-10-15.pdf
d:\Folder\2021\01\

.......

B) MANAGE FOLDER, MOVE TO ARCHIVE

Is there possible then based on actual date move whole folder to archive folder?
With rule: with every creating of new month folder check move to archive minus 2 months – mean in 04 month move 02 folder, 05 month move 03 folder..etc.. only in 02 month move whole year folder to d:\Folder\2021\ to X:\Archive\ ?


Thank you for help with code base.
vendam

Hi vendam,

Try the following code in the attached sample file. You may have to modify the 3 lines in red at the top of the Code module to fit your specific requirements.

I suggest you try the code on dummy folders before attempting to use it on real data, since file deletion is involved. Back up your files in the Source folder before you try the code on real data.

Please Login or Register  to view this content.

Please let me know if you have any questions and/or problems.

Lewis

Dear Lewis,

thank you very much for your help, tested and it works perfectly without no complication found.
Saving created folders. After manual adding of old folder with files - macro sent all package to archive folder.

Huge respect and thanks for help!

vendam