Looping through each file in a folder

[Sandler]

I am looking for code that will loop through each file in a folder. This would be the shell for a program I am trying to create.

So far I know to pick the folder, i can use something like this

With Application.FileDialog(msoFileDialogFilePicker)

Thanks

 

[Sandler]

Thanks Fishboy. I hope you are feeling better.
In the first 2 weeks of the month, I am not as active either, due to the nature of my job.
The files I speak of have payroll information, so I will manually set up 3 similar files with made up individuals and with made up payroll.

I just got my copy of Walkenbach's Power Programming 2013 via Amazon this morning.
I was browsing through his Excel VBA for Dummies for the second time and the book definitely makes more sense now.
It's the postings I get from the Excel forums that help me (a non-programmer) really understand these books. So, thank you