>How can I create a table with information about files that are stored on several CD's?
>
>What I mean is, something like: DIR D:\ > DIR.TXT
>
>The function ADIR() does this, and puts the directory content into an array, but what if some directories have more sub-directories???
>
>Thanx in advance
Ron,
You'd have to recurse the directory tree using ADIR() (eliminating the current and parent directory entries, of course). There have been several examples of this posted here.
Slightly easier, but more time consuming, would be to use the Windows Script Host's FileSystemObject, which exposes a files and folder/subfolders collections. Of course, it would have to be installed, and whether or not that is the case depends on several factors.
George
Ubi caritas et amor, deus ibi est