Pulling User Environment Settings

[jtgarrison]

I'm trying to pull some user settings in VBA, but I'm not quite sure what the correct syntax is.

I'd like to pull the logged on User Name's My Documents, no matter what version of Windows they are using...XP, 7, or 2003. I think the syntax is Environ("userna me"), but how do I get Username\My Documents regardless of what version?

Thanks.

[FishVal]

I'm trying to pull some user settings in VBA, but I'm not quite sure what the correct syntax is.

I'd like to pull the logged on User Name's My Documents, no matter what version of Windows they are using...XP, 7, or 2003. I think the syntax is Environ("userna me"), but how do I get Username\My Documents regardless of what version?

Thanks.

You can use Windows Script Host Object library to retrieve path to "MyDocument s" folder.

[jtgarrison]

Actually, I figured it out....It's Environ("userpr ofile")&"\"&env iron("username" )&"\" &"My Documents".

Thanks.

[NeoPa]

That's pretty close. I would use :

Replace("%P\My Documents", _
        "%P", _
        Environ("USERPROFILE")