Microsoft Office Tutorials and References
In Depth Information
Getting a List of Filenames
In response to your command, Windows creates a file named upper in the current directory (the
one you specified in Step 3). You can then use Excel’s File
Open command to import this file,
which starts the File Import Wizard. (Make sure to specify fixed-width data.) Figure 181-2 shows
some data that I imported.
Figure 181-2: This file listing was imported from a text file.
As you can see, the listing needs to be cleaned up a bit, but all the information is there, including
the date, time, and size of each file.
The DIR command has quite a few options. For example, you can get a list of the files
in all subdirectories as well as the current directory by using this statement:
dir/s > filelist.txt
Search online for DOS DIR command, and you’ll find lots of information about the DIR