Importing All Files in a Folder

Hi everyone. I'm pretty new to excel macros and VBA, but I'm trying to figure out tricks that will make my work go more smoothly.

What I'm working on now is a series of experiments that each generate .csv files, which I then do some simple data analysis on. I want to make a macro that will take a csv file, import it to a specific worksheet, do the analysis, clear that worksheet, and then move on to the next file and do the same thing. It would run the same analysis on every csv file in a specific folder, and give me a summary at the end. It's all straightforward, for the most part, and I can puzzle through most of it. The only problem I'm running into is this: the files aren't being generated with a predictable naming scheme, so I can't just set it to a simple for loop. Is there any way to do this in spite of that?

If you don't need to open files in defined order ther'is no problem with this loop

Sub OpenTxtFiles()
Dim folderPath As String, fileName As String, WB As Workbook
folderPath = "D:\test\"
fileName = Dir(folderPath & "*.csv")
Do While fileName <> ""
   Set WB = Workbooks.Open(folderPath & fileName)
   'your code here
   WB.Close False
   fileName = Dir
Loop
End Sub