Excel VBA Macro: Create Folders Based on Month and Year in Excel for Mac (Step-by-Step Tutorial)

Excel VBA Macro: Create Folders Based on Month and Year in Excel for Mac (Step-by-Step Tutorial). In this video, we create a macro that dynamically creates folders based on the year and month. If you ever need to automatically create folders based on the year and month, with Excel VBA you can use the code we write in this video to create these folders automatically without having to manually create folders. The code will use the current date and determine what the current year is; if that folder already exists, nothing will happen, but if that folder doesn't exist the macro will create a new folder with the current year automatically. The same for the month: if a folder with the current month does not exist, a new folder with the current month will be created. This is extremely useful when using Excel VBA to save newly created files in an organized way. This way, the user does not have to remember when to create a new folder when the month and year change because it is atomically done for you, without any human error.

Data used in this video:

#ExcelVBA #ExcelMacro

[naomifagan]

Keep getting error, script debug error will create year folder but not month folder