Whats Next

In the course of this chapter, you learned and tried out VBA functions and statements that allow you to work with the file system. You found out how to read and modify information pertaining to files and folders, as well as how to perform the read and write operations on files opened for sequential, random, and binary access. You also learned how to use the Windows Scripting Host (WSH) to access the FileSystemObject and perform other operations, such as launching applications and creating Windows shortcuts with the WshShell object. If you are interested in details of the discussed functions or statements, spend some time now browsing the Visual Basic online reference.

The next chapter introduces you to more automating tasks. You will learn, for example, how to use VBA to control other applications. You will learn various methods of starting applications and find out how to manipulate them directly from Microsoft Excel.

This page intentionally left blank

0 0

Post a comment