>I have written the included code to find a subdirectory name and then create an array of all of the .mdb files in the subdirectory. Have I done a good job or is there a faster/more efficent way to do this? I used dynamic arrays to store the subdirectory names and the file names. The problem is that the subdirectory names will always be changing. The directory structure is as follows:
>
>
>
>root
> application
> STATSDB
> 0008
> 0009
>
>
>where the 0008 represents the statistics for a particular month. I have stored the drive:\root\application\STATSDB\ part of the path in the registry with the SaveSettings command.
>
>I am writting my first "real" VB program and it has gotten complex fast.
>
>Thanks for the help,
>
>GW
>
Look at the FileSystemObject object model. It's made just for that. Not the writing to the registry though.