How to append all excel files from a directory (plus problem with local macros)? - Statalist

I have a folder (with subfolders) containing many excel files. Each file has two columns: Name and Code. I'm trying to figure out a way to import and combine

www.statalist.org