I would like to list the filenames of all files in "C:\My Documents"
How do I do this?

I can count them with this but I need to list their names.'count files in a directory

Dim iFiles As Integer
Dim sDir As String
sDir = Dir("C:\My Documents\*.*", vbNormal)
While sDir <> ""
iFiles = iFiles + 1
sDir = Dir
Wend