Thanks for the link! The solution appears to be far more complex than what I
really need. However, I will retain the link for potential future use.
Bob


"JMB" wrote:

Chip also has information on his site:

http://www.cpearson.com/Excel/SpecialFolders.htm


"Bob" wrote:

Is there a way to find a user's complete path to the location of their My
Documents folder and assign that path to a variable called pname?

For example, the complete path to my My Documents folder is:
C:\Documents and Settings\bob\My Documents\

So I would want pname = C:\Documents and Settings\bob\My Documents\

Thanks in advance for any help.
Bob