Need path from Open dialog box call
Is there a way to read the path from the Open dialog box once a user navigate to a file? Using the code below:
' Display the Open dialog box and allow a user to select multiple files to open.
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog(FileDialogType:=msoFileDial ogOpen)
With dlgOpen
.AllowMultiSelect = True
.Show
End With
Thanks
|