Should the user's selection of a file in the file dialog open actually open
the selected file or does it just select the file?

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
End With