There may be many situations in your VBA project when you might need to open up the dialog box and choose a file to carry out a task with.
This simple and quick solution will do just that, open up the dialog box at default C: and allow you to choose a file (fname). You can then choose what happens to fname, open it, record the folder and path in a cell or userform textbox for instance.
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = True
.InitialFileName = "C:\"
For Each fname In dlgOpen.SelectedItems