I have a system change coming up, and I don't know how large of an impact it will have.
I am able to search using windows for every .txt file on a shared drive... and it will search the subfolders all the way down. But I'm trying to bring that information back into excel, and windows... well it doesn't cut the mustard.
Does anyone have a tool that runs in vba where I can put in the parent directory I want, then have it search for all files with the .txt file format, then put that information in excel? I know its a big ask, but I can't be the only one that's had to come up with a solution for this.