SelectFile.vb

Function SelectFile() As String
 
    'Open the file dialog
    With Application.FileDialog(msoFileDialogOpen)
        .AllowMultiSelect = False
        .Show
 
        'Set function result to selected filename
        If .SelectedItems.Count <> 0 Then
            SelectFileName = .SelectedItems(1)
        End If
    
    End With
 
End Function