Hi Neil,
You can chk XDIR tool here on downloads.
It is class object for directory scan including subflders.
There is example there of filling up cursor with all directories and tables.
Source is there so you can filter out only xls file.
Rgds++

>Fantastic Thanks John,
>
>I have done this but it onyl does this for the current folder. How do I change this code so that it includes all subfolders within U:\QuestPDM\Vault
>
>

>CLOSE DATABASES
>SET DEFAULT TO U:\QuestPDM\Vault
>
>gnDbcnumber = ADIR(gaDatabase, '*.XLS')  && Create array
>
>CLEAR
>FOR nCount = 1 TO gnDbcnumber  && Loop for number of databases
>   ? gaDatabase(nCount,1)  && Display database names
>ENDFOR
>

>
>Thanks