Answers for "excel vba FileDialog"


excel vba FileDialog

sub xFilePicker()
  Dim fDialog As FileDialog
  Set fDialog = Application.FileDialog(msoFileDialogFilePicker)

  'Show the dialog. -1 means success!
  If fDialog.Show = -1 Then
     Debug.Print fDialog.SelectedItems(1) 'The full path to the file selected by the user
  End If
end sub
Posted by: Guest on April-19-2022

Code answers related to "VBA"

Browse Popular Code Answers by Language