I wrote some VBA for a co-worker and everything was pretty simple because I
knew she was using Windows 98 and the location of the My Documents folder
could be accessed with "C:\My Documents".

But now, I have been asked to make this work for others that may be using
Windows 2000 or windows XP. I have realized that the location of the My
Documents folder on Windows XP is "C:\Documents and Settings\Ken\My
Documents".

Now I realize I need to somehow test for or determine the location of the My
Documents folder.

Can someone please suggest an online article about this or give me some
suggestions?

Thanks,
Ken