The path of the download folder

[eran3185]

Hi

Is there a way to get the path of the download folder with a vba code ?

 

[mumps]

The path would be: "C:\Users\YourUserNameHere\Downloads"
Replace the letters in red with your environment username. If you're not sure what that username is, run this macro.

Sub EU()
    MsgBox Environ$("username")
End Sub