VBA HELP Command button

[CodesiriuS]

Hello - Im new to VBA and Im trying to make a userform that has a button that pretty much launches the window explorer but then lets the user navigate through the directory and upon selecting a file - also opens it so they can utilize other macros to format it. I have this so far but I don't know the code to open the file

Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "file:\\c:"
End Sub

 

[CodesiriuS]

Thank you I appreciate it - do you happen to know the best resources out there or best ways about learning VBA it sucks not knowing what you dont know