Get Directory Path of My Documents

[YasserKhalil]

Hello everyone

In my attachment I have put four methods to get the directory path of my documents

Hope this may be useful for you

 

[Hui]

Thanks Yasser

Your line: MsgBox Environ("USERPROFILE") & "/My Documents"
Should be: MsgBox Environ("USERPROFILE") & "\My Documents"

 

[YasserKhalil]

You're welcome Mr. Hui
Thanks a lot for reply and for this remark