Get Filename

  • Thread starter Thread starter Arnie
  • Start date Start date
A

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
 
Sorry should be (no .InitialFilename)

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