Folder Contents

[dhaveedh]

Does anyone know how i can get the list of files in a folder in Access?

I want to list all the files in a folder and find out if a particular file exists.

Help appreciated.



KISS - Keep It Simple Sugar!

 

[drctx]

you could do something like this:

Dim SnapFile As String

SnapFile = "C:\" & "Quote " & quoteno & " Revision " & revno & ".snp"

' check if file exists
If Dir(SnapFile) <> "" Then
MsgBox "File exist."
Else
MsgBox "File does not exist."
End If

 

[vbajock]

Google "FileScriptingObject". There is so much code out there on it you can probably cut and paste what you need