با سلام
Public Function FolderSelection() As String
Dim objFD As Object
Dim strOut As String
strOut = vbNullString
'msoFileDialogFolderPicker = 4
Set objFD = Application.FileDialog(4)
If objFD.Show = -1 Then
strOut = objFD.selecteditems(1)
End If
Set objFD = Nothing
FolderSelection = strOut
End Function
Public Function FileSelection() As String
Dim objFD As Object
Dim strOut As String
strOut = vbNullString
'msoFileDialogFilePicker = 3
Set objFD = Application.FileDialog(3)
If objFD.Show = -1 Then
strOut = objFD.selecteditems(1)
End If
Set objFD = Nothing
FileSelection = strOut
End Function
منبع
http://www.fardanesh.ir/%D8%B4%DB%8C...9%D8%B3%D8%B3/