Performing Common File Operations

Excel provides you with a number of ways to perform common file operations:

♦ Use traditional VBA statements and functions. This method works for all versions of Excel.

♦ Use the FileSearch object, which is easier to use and offers some distinct advantages. This method works for Excel 97 and later.

♦ Use the FileSystemObject, which makes use of the Microsoft Scripting Library. This method works for Excel 2000 and later.

In the sections that follow, I discuss these three methods and present examples.

0 0

Post a comment