Checking Files in a folder

[robcarr]

Dear All,

Is there a way to count how many files are in a specific folder using VBA, I need at the end of the month to know how many .xls files are stored in a folder, and if the number is less than the number of days in the month, I need to know what days are missing from the folder, the missing file names need to be added to a worksheet,with the folder name on it, so I know how many files for that folder a re missing. I have to run the routine for 11 different folders, the file names for each file in each folder is dd.mm.yy.xls

Is this possible?

Thanks for any help on this.

 

[xlbo]

Rob - check this thread.
To make it work for multiple folders, just add an exterior loop - assuming you have a list of folder paths in A1:a11 in sheet1
For i = 1 to 11
myPath = sheets("Sheet1&quot.range("A" & i).text
'do interior loop to count files
Next i

HTH Rgds
~Geoff~

 

[xlbo]

D'oh - forgot the thread
thread705-256951 Rgds
~Geoff~