Access.2007.VBA.Bibl..

The FileSystemObject ..............................................................................................

The FileSystemObjectlibrary provides another way to work with Windows folders (and files).

To use the components of the object library in a database, you need to set a reference, in this case

to the Scripting Runtime library, as shown in Figure 9.5.

If you don’t see the Microsoft Scripting Runtime selection in the References dialog, you can get this

library by downloading Microsoft Windows Script 5.6 (or whatever is the current version), plus

the Microsoft Windows Script 5.6 Documentation files from the Microsoft Windows Scripting

Downloads page at http://www.microsoft.com/downloads/details.aspx?

familyid=01592C48-207D-4BE1-8A76-1C4099D7BBB9&displaylang=en.

FIGURE 9.5

Setting a reference to the Scripting Runtime library.

The Help file shown in Figure 9.6 (script56.chm) is a compiled HTML Help file. You’ll find it

very helpful, because it includes a Help book with full information on the components of the

FileSystemObject, plus useful code samples.

Working with Files and Folders 9