Locating the My Documents Folder

Summary: Need to do some macro processing of documents in the user's My Documents folder? First step is to figure out where the folder is located. Here's the easiest way to figure out the path. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

When creating a macro, you may need to know the full path to the user's My Documents folder. The path can differ, based on the system and the user logged into the system. The easiest way to locate it is through the use of the Environ function, as shown here:

MsgBox Environ("userprofile") & "\My Documents"

This code line displays the full path (including the drive letter) in a message box. If you want to have the path assigned to a string variable instead, you can use this code line:

sMyPath = Environ("userprofile") & "\My Documents"

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

More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want.

Check out WordTips: The Macros today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Locating the My Documents Folder