excel vba FileDialog

The solution for “excel vba FileDialog” can be found here. The following code will assist you in solving the problem.

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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts