Thanks, that did the trick. I didn't think about when the data was being generated. Quick question that I thought of for when this gets rolled into an HTA, can a function be within a sub?
Here's what worked:
Dim GoodFileCnt, BadFileCnt, GoodMsg, ErrorMsg
Set objShell =...