[RESOLVED] get "my documents" path

[lplover2k]

is there a way to get the "my documents" path....

(e.g. c:\my documents and settings\[username]\)

but sometimes the "my documents" is like

c:\my documents and settings\all users\ or
c:\my documents and settings\administrator\

[Siddharth Rout]

Hi

download the code at

http://www.thescarms.com/vbasic/specialfolders.asp

Hope this helps...

[gavio]

Here's a simpler way:

Debug.Print Environ("HOMEDRIVE") & Environ("HOMEPATH")

But it's not 100% reliable tough

[lplover2k]

Here's a simpler way:

Debug.Print Environ("HOMEDRIVE") & Environ("HOMEPATH")

But it's not 100% reliable tough

thx what's the most reliable way then??

[RhinoBull]

The most reliable way is the Windows API way:

Retrieve Windows Shell Folders (Best Practice)

[gavio]

The one RB posted... well, Environ() is reliable, but can be changed by the user - so...

[lplover2k]

solved thanks very much!