Changing Directories in a Macro

Summary: When a macro works with files, it often has to change between different directories on your disk drive. This is done using the ChDir command, as described in this tip. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

You have learned you can use the MkDir command to create directories, and the RmDir command to delete them. But how do you switch to a directory? VBA uses the ChDir command to do this. The syntax is as follows:

ChDir DirName

where DirName is the full pathname of the directory to which you want to change. If you do not use a string variable to specify the directory name, then DirName must be enclosed in quotes. If the directory name you supply does not exist, the command fails with an error.

Tip #3465 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Tremendous Table Tips! We often take tables for granted, but Word includes some very powerful ways you can present your tabular data. Discover how to make your tables better, easier to understand, and more effective.

Check out WordTips: Terrific Tables today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Changing Directories in a Macro