>Hi !
>
>Is anybody have an idea to get the total numbers of files of a folder. We have more than 20000 files in a folder and we want to check the total numbers of files exist in folders.
>
>We have tried =ADIR() function to the same but it give an error "Invalid subscript reference" or "subscript out of range".
>
>
>Thanks in advance
>Ravi Mehrotra
I just tried
?ADir(dummy,'mypath\*.*')
with a directory with more than 54000 files. Worked fine.