'方法一:
Dim FileName As String
FileName = Application.GetOpenFilename("Excel 文件 ,*.xls;*.xlsx")
'方法二:
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.InitialFileName = "D:\" '打开时默认的目录
.Filters.Clear
.Filters.Add "Excel文件", "*.xls;*.xlsx"
.Title = "请选择文件"
.Show
For i = 1 To .SelectedItems.Count
MsgBox .SelectedItems(i)
Next
End With