Check For Empty Folder

[Hackster]

I know who to check to see if a folder exists, but how do I check to see if an existing folder is empty? I don't need to know what files are in it, I just need to know whether it has any files or no files.

Thanks.

 

[dwlerwill]

You could do it via filesystemobject try the attached link for samples you can use/modify

http://www.vbwm.com/art_1999/whatsnew/filesys.asp

David Lerwill
"If at first you don't succeed go to the pub"

 

[bjd4jc]

Here is a non-FSO based solution:

If Dir("C:\TestDir\*.*") = "" Then
     'Directory Is Empty
Else
     'It has one or more files in it
End If

 

[Hackster]

Thank you both. I have what I need!