why don't you use doc and settings\all users\documents? that's a shared
resource for anyone that logs in

--


Gary


"Ken Loomis" wrote in message
...
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