File listing function?

[EvilCabal]

Hello,

I am looking for a simple function that could give me the file listing for a given directory. As far as I know access doesn't have one. I've also looked in the Win Api functions listing without success. I'm confident there are many ways to do that but I can't find them!

Thank you for the help.

 

[GHolden]

You can use the Dir function. Example below returns all files in a specific path as a string delimited by commas. This is just an example see help for more info..

Function mDirListing(ByVal vstrPath As String) As String
Dim strCurrentFile As String

strCurrentFile = Dir(vstrPath & "*.*&quot

If strCurrentFile <> vbNullString Then
mDirListing = strCurrentFile

Do While strCurrentFile <> vbNullString
strCurrentFile = Dir
If strCurrentFile <> vbNullString Then
mDirListing = mDirListing & &quot;, &quot; & strCurrentFile
End If
Loop

End If

End Function

'Call the function like this..

Sub test()
MsgBox mDirListing(&quot;C:\&quot
End Sub

There are two ways to write error-free programs; only the third one works.