VBA打开文件对话框

Dim fileOpenName
fileOpenName= Application.GetOpenFilename("Excel文件(*.xls),*.xls")
If fileOpenName<> False Then
    MsgBox "Open " & fileOpenName
End If

编程技巧