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

Great Idea! Word is a tool to get what you really want—printed output. This means you need to make sure that Word works as well as possible with your printer, whether it is sitting on your desk or in a room down the hall.

Check out WordTips: Printing and Printers today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Locating the My Documents Folder