Microsoft Office Tutorials and References
In Depth Information
Creating a List of Files That Reside in a Directory
Next Rw¶
'Restore screen updating¶
Application.ScreenUpdating = True¶
End Sub¶
In the 'Change the following variables' section, the range that is processed can
be defined and coded directly into the macro. By default, it uses the range that
is currently selected.
Exl
Creating a List of Files That Reside in a Directory
Use this macro to create a list of all the files in a path (and its subfolders) and
to include a number of properties about each of them.
Example file:
E024.xls
Scenario: Sometimes it is helpful to have a list of all the
files within a directory (and subdirectories). For example,
when the information stored on a server is going to be
moved to a different server, to validate that all the files have
been moved correctly and completely. This macro can serve
that purpose.
It could also be used to verify the size of the different files in
order to determine which ones are occupying more space
than they should.
Figure 28 – Directory Listing
View the Appendix to learn how to store this procedure
in a Standard module.
 
Search JabSto ::




Custom Search