I have a folder that can contain any number of files.

I want to open each one pull some data from it onto a master spreadsheet, save it in a sub folder and then close the saved file and delete the original file.

I am confident I can write the code saving file in subfolder and deleting original, where I am struggling is the code for opening non specified files until there are no more.


Thanks in advance.