YasserKhalil Well-Known Member Oct 18, 2016 #1 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 Attachments Get Directory Path Of My Documents.xlsm 16.5 KB · Views: 19
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 Excel Ninja Staff member Oct 18, 2016 #2 Thanks Yasser Your line: MsgBox Environ("USERPROFILE") & "/My Documents" Should be: MsgBox Environ("USERPROFILE") & "\My Documents"
Thanks Yasser Your line: MsgBox Environ("USERPROFILE") & "/My Documents" Should be: MsgBox Environ("USERPROFILE") & "\My Documents"
YasserKhalil Well-Known Member Oct 18, 2016 #3 You're welcome Mr. Hui Thanks a lot for reply and for this remark