Solved Open Folder images in Win 11

[sergio vieira]

Good evening everyone. Does anyone know if it is possible to open the Images folder in Win 11 from a command button?

 

[theDBguy]

What is the path to it? Is it different for every user/machine?

 

[moke123]

I think the path is C:\Users\ {Your User Name} \Pictures.

You can get it with :

Option Compare Database
Option Explicit

Declare Function Get_User_Name Lib "advapi32.dll" Alias _
    "GetUserNameA" (ByVal lpBuffer As String, _
    nSize As Long) As Long

Function GetUserName() As String

    Dim lpBuff As String * 25

    Get_User_Name lpBuff, 25
    GetUserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)
    
End Function

Function PathToPictures() As String
 
    PathToPictures = "C:\Users\" & GetUserName & "\Pictures"

End Function

In your button click event

Application.FollowHyperlink PathToPictures

 

[The_Doc_Man]

The only catch is that Win11 might have more than one file named "Pictures" and so perhaps you should manually browse to decide which path you need before you program it. I'll agree with Moke123 that it SHOULD be the path C:\Users\<username>\Pictures - but it pays to investigate first and THEN program your desired path.

On my Win11 there was a feature to allow me to designate the drive on which files are stored, and "My Pictures" was one of the moveable folders. I moved it from the SSD to the HDD on my system. (Don't trust SSD drives really well since I've had them fail on me.) Therefore, for user "Default" there is a C:\Users\default\Pictures path, but for me the path is D:\Users\Richard\Pictures. There is ALSO a D:\Pictures path that has no username associated with it, and my C: drive also has a C:\Users\Public\Pictures path.

Bottom line: Scout ahead to see which way this will lead you.

 

[sergio vieira]

Thank you to all of you. Your informnation was very usefull, Doc Man. Thank you MOKE 123 your code was perfect. Problem solved.