Get Filename

[Arnie]

Morning All,
i am using this code to select a file but don't know how to pass the
filename and path
to a varriable?

Dim dlgOpen As Office.FileDialog
Set dlgOpen = Application.FileDialog(msoFileDialogFilePicker)
With dlgOpen
.Show
.AllowMultiSelect = False
.InitialFileName
End With

thanks in advance

 

[Arnie]

Sorry should be (no .InitialFilename)

Dim dlgOpen As Office.FileDialog
Set dlgOpen = Application.FileDialog(msoFileDialogFilePicker)
With dlgOpen
.Show
.AllowMultiSelect = False
End With