Welcome to Over50sForum! The site for people over 50 to chat, make friends, discuss, share, and generally be part of something that's fun and friendly :)
Yes I enjoy Excel but my particular interest is VBA with makes things easy to use.
I also like batch files a left over from the magical days of DOS again they make life so much easier and quicker. This one just goes through any subdirectories and creates a list of films.
@echo off
setlocal enabledelayedexpansion
set "SourceDir=%~d0"
REM Check it is not C: Drive
if %SourceDir%==C: (
echo.
echo DO NOT RUN THIS ON C: Drive
echo.
goto eof
)
REM Set Source and Destination
REM These WILL need changing for different drives
set "FilmDir=%SourceDir%\Films"
set "TVDir=%SourceDir%\TV"
Rem Delete old file and create new one
Echo Film List created on %date% at %time% > "%FilmDir%\Film List.txt"
Echo -------------------------------------------------- >> "%FilmDir%\Film List.txt"
REM Find Directories
for /d /r "%FilmDir%\" %%G in (*) do (
Set NewVar=%%G\
for %%F in ("!NewVar!*.*") do (
if not %%~xF==.srt (
Echo %%~nF >> "%FilmDir%\Film List.txt"
)