CodesiriuS
New Member
- Joined
- Dec 18, 2016
- Messages
- 27
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
Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "file:\\c:"
End Sub