So have to run a report every week and the folder structure is set up (see example below)
eg:M:\Weekly Reports Open Reqs\2019\July 2019\Open Req Weekly 07.22.2019
can i automate this process so that way i can have it create all the said folders, such as, if 2019 exists, then move on to “JULY 2019” And "Open Req Weekly (whatever date)
or if i need to create a new year folder with the current year and so on down the line?
any help is greatly appreciated