Find Path

[Rafi]

How do I find the the complete path to the My Documents folder? My users
will have their My Documents folder in C:\Documents and Settings\xxxxx\My
Documents and I need to find the value of the xxxx for each user that opens
the application.

Thanks for your help

 

[stefan hoffmann]

hi Rafi,

How do I find the the complete path to the My Documents folder? My users
will have their My Documents folder in C:\Documents and Settings\xxxxx\My
Documents and I need to find the value of the xxxx for each user that opens
the application.

You can use Environ("USERPROFILE"). The "C:\Documents and Settings\"
part of the profile path may be different for each user on one system.


mfG
--> stefan <--

 

[Douglas J. Steele]

You can use Environ("USERPROFILE"). The "C:\Documents and Settings\"
part of the profile path may be different for each user on one system.

It's more reliable to use the API approach shown in
http://www.mvps.org/access/api/api0054.htm at "The Access Web"