I often use Dir$() in VBA in my day job, to batch process folders of Word documents. But it doesn’t handle subfolders. For years I’ve put off learning an alternative method because VBA arrays make my head hurt. Today, I had hundreds of subfolders to work on, so did it at last.