Creating Folders and Sub Folders and Saving Files Using Excel VBA

[auraitsuka]

I do reports on an everyday basis and I want to create a macro to make it easier to save the reports. This is the pathway on files explorer currently: C:\User\Documents\test\reports (2022)\3. March. As you can see, I’ll have to make a new folder every new month and year to save my report, which is tiring. Is there a way I can make all of these to vba?

Thank you and sorry for the broken English.