Create MediaElch Compatible Movie & TV Folders from Excel

[GarfieldS]

Excel Folder Creator

Using this simple spreadsheet you with 4 columns you can enter

1. Media Type (TV Shows or Movies)
2. Media Title (TV Show or Movie Name)
3. Seasons (number of seasons)
4. Status (Creation Date of existing folders)

After entering this info and running the macro the macro will

1. Ask you if you are ready to run the macro. If now you can cancel
2. If you are ready it will open up a Folder picker dialogue box to select the folder that will contain your "TV Shows" and "Movies" Folders. If they don't exist the macro will create them.
3. If your media is a TV Show it will create a folder with the name of the TV Show under the "TV Shows" Directory
   It will also create folders for the number of seasons you indicate in the spreadsheet. If empty it will prompt you to enter a value and the default value will be one.
4. If your media title is a Movie. It will create a folder under the "Movies" subfolder and copy a sample video file into the folder with the name of the movie as the video file name.
5. As it goes through each row it will mark created folders with a status of "Created on" and the date the folder was created. You can add more titles later and it will skip folders that were already created.

This is done using Excel and VBA. The link to the file is included below:
Link to File

This is my first time posting something like this so if there is something I should be doing that I am not doing let me know.
You can review the code before enabling it as Excel Files with macros can contain viruses. I can also share the vba code. A reference to the Microsoft scripting runtime will be needed.

If you have any questions let me know.