WMC Library Excel Macro

[wmc2001]

Here is an Excel Spreadsheet/Macro I developed to do things:

• list all the .wtv files on my system
  highlight the duplicate titles

The detailed instructions are located on the worksheet of the same name.

In short, you'll need to:
Unzip the attachment. A copy of the macro source code is included. Caution should be always be exercised before running any macro.
Set up network shares to the drives where your wtv files are stored (i.e. \\MEDIASERVER-PC\Main, )
Configure the folders on the DrivePaths worksheet (i.e. \\MEDIASERVER-PC\Main\Recorded TV\ , \\MEDIASERVER-PC\Main\Library\, \\MEDIASERVER-PC\Main\Videos\)
Run the Get_Recordings() macro. This macro will search though three levels of folders.
This macro will read then parse the components of the standard WMC file naming convention ( i.e. Diamonds Are Forever_UHD_2015_06_07_18_58_00.wtv) and then add a row to the worksheet named Recordings.
Run the Highlight_Dups() macro. This macro will sort the recordings by Title and highlight any duplicates.