Have a look at the DirPlus() UDF. It can enumerate items (folders or files or both) in a folder and puts the results into an array. Sound exactly like what you need.
The interesting thing with DirPlus() is when I display the number of files found in the console window (calculated by using the UBOUND() function), I seem to get a lot of results that are -1 and I seem to get a result of zero if there is only a single file in, for instance, the Desktop folder.
Any ideas?
