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("username"), but how do I get Username\My Documents regardless of what version?

Thanks.

[FishVal]

@jtgarrison
You can use Windows Script Host Object library to retrieve path to "MyDocuments" folder.

[jtgarrison]

Actually, I figured it out....It's Environ("userprofile")&"\"&environ("username")&"\" &"My Documents".

Thanks.

[NeoPa]

That's pretty close. I would use :

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