View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Beckinsale Michael Beckinsale is offline
external usenet poster
 
Posts: 80
Default Check if directory empty OR no of files in directory.

Hi All,

I am in the middle of writing code for a spreadsheet solution and need to
check whether a specific directory is empty or not.

Can anybody tell me what the code is to do that please. ?

Alternatively does anybody know the code to count the number of files in a
directory ? I could then apply an IF 0 type statement to achieve the same
result.

All suggestions gratefully received.

Regards

Michael beckinsale