'方法一:
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
EXCEL-VBA:弹出对话框,打开文件(指定扩展名)两种方法
最新推荐文章于 2024-05-03 11:48:00 发布