Data Mining in Excel - Automated Data Analysis Using Excel - page 215

FIGURE 5.35 Example of desired report.
full path to these files) will be stored in the array FileNames() . In this example, the following
elements would be stored in FileNames():
1 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound1\method40\20040219-150100.xls
2 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound1\method50\20040219-150200.xls
3 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound1\method60\20040219-150300.xls
4 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound1\method70\20040219-150400.xls
5 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound2\method40\20040219-150500.xls
6 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound2\method50\20040219-150600.xls
7 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound2\method60\20040219-150700.xls
8 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound2\method70\20040219-150800.xls
9 C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound3\method40\20040219-150900.xls
10C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound3\method50\20040219-151000.xls
11C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound3\method60\20040219-151100.xls
12C:\Author\Books\Excel\Chapter
5\Samples\AutoLoadDirs\Compound3\method70\20040219-151200.xls
While on the subject of creating file lists, it would also be lucrative to have a function that would
create a list of directories below a file structure that is pointed to. The function CreateDirectory
List whose source code follows will accomplish this task. Notice that, like its big brother, the
FIGURE 5.36 Autoload and Extract sample GUI.