Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Arranging Document Windows

Specifying a Backup Location

Controlling Chart Gridlines

Merging Table Cells

Collapsing and Expanding Subdocuments

Zooming With the Keyboard

Initiating a New Search

 

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!