Hi Everyone,
Hope all is well.
I require code to create folders in a specific drive.
The code must do the following:
Go into folder path \\Server\Main Folder\Data Loads\
- If today is the 1st March, I have to save 5 files in a folder "February 2015' in a subfolder "20150228". So always the day before
The code must check if folder "February 2015" exists. If it does exist, check subfolders if folder "20150228" Exists. If not create it and save files in it.
Therefore:
- If today is the 2nd March, I have to save 5 files in a folder Dataloads/March 2015/20150301.
- If today is Monday 2nd March, I have to save 5 files in a folder Dataloads/March 2015/20150227 (Friday past).
I have code but its crap and deleted all my work and i'm afraid to use it.
This is a daily task so months changing and years changing needs to be considered too.
Please assist
Thank you kindly.
Hope all is well.
I require code to create folders in a specific drive.
The code must do the following:
Go into folder path \\Server\Main Folder\Data Loads\
- If today is the 1st March, I have to save 5 files in a folder "February 2015' in a subfolder "20150228". So always the day before
The code must check if folder "February 2015" exists. If it does exist, check subfolders if folder "20150228" Exists. If not create it and save files in it.
Therefore:
- If today is the 2nd March, I have to save 5 files in a folder Dataloads/March 2015/20150301.
- If today is Monday 2nd March, I have to save 5 files in a folder Dataloads/March 2015/20150227 (Friday past).
I have code but its crap and deleted all my work and i'm afraid to use it.
This is a daily task so months changing and years changing needs to be considered too.
Please assist
Thank you kindly.
