I'm writing a macro that opens a static folder and then copies specific data
from all the files in that folder to manipulate. I can write the code to
open a file by specifying the exact filename. I need to learn how to open a
file (all the files in a particular folder) one by one without knowing:

1)the filenames
2)how many files are in the folder

ahead of time. Please help