Anyone can help me with code to loop through all files in a folder [DATABASE ERROR]

Loop through all files in a folder and all files in subfolders,.... Basically all the files under parent folder.

Then return full file path to a sheet (activesheet).

Thanks.

Moderator's note: I updated the title as a workaround to resolve an internal database error. --6SJ