Chapter 12Chapter 12
File and Folder
Manipulation with
VBA
Manipulating Files and Folders + Finding Out the Name
of the Active Folder + Changing the Name of a File or
Folder + Checking the Existence of a File or Folder +
Finding Out the Date and Time the File Was Modified +
Finding Out the Size of a File (the FileLen Function) +
Returning and Setting File Attributes (the GetAttr and
SetAttr Functions) + Changing the Default Folder or Drive
(the ChDir and ChDrive Statements) + Creating and Delet-
ing Folders (the MkDir and RmDir Statements) + Copying
Files (the FileCopy Statement) + Deleting Files (the Kill
Statement) + Chapter Summary
287
In the course of ...
Get Excel 2007 VBA Programming with XML and ASP 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.
