File Management

File management consists of tasks such as creating and deleting folders, moving and copying files, and getting information about the disk drives on a system. VBA offers two ways to perform file-management tasks: the newer object-oriented techniques and the traditional Basic statements and functions. Both methods work perfectly well, but I recommend that you use the object-oriented techniques in your own programs. This section is devoted mostly to covering the object-oriented, file-management techniques and presents only a brief overview of the traditional methods so you can recognize them if you see them in someone else's code.

Object-Oriented File Management

The object-oriented, file-management techniques are based upon the ...

Get Office® XP Development with VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.