Tips.Net > WordTips Home > Macros > Changing Directories in a Macro
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
Ultimate Library! An amazing resource that brings together, in one place, the collected knowledge of everything ever published in WordTips. The library combines two powerful elements to make you more productive: solutions and convenience. Here's where you get your own copy of everything ever published in WordTips.
Check out WordTips Ten-Year Library today!
Great Support Resource!
If you provide support and help to others, you need the power offered in the WordTips Ten-Year Library. There is no better information repository anywhere! (more information...)
Helpful Links
Ask a Word Question
Make a Comment
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips