|
本帖最后由 Dj_soo 于 2012-5-21 16:57 编辑
- '打开Excel文件,并将此工作簿赋值给函数
- 'Title设置打开文件对话框的标题,filtername可以设置打开类型的名称,filterTypes设置类型后缀
- 'InitialFileName设置初始化的路径
- Function OpenXlsFile(Title As String, Optional filterName As String, Optional filterTypes As String, Optional InitialFileName As String) As Object
- Dim Brs As Object
- Dim FilePath As String
- Set Brs = Application.FileDialog(msoFileDialogFilePicker)
- With Brs
- .AllowMultiSelect = False
- .Title = Title
- .InitialFileName = InitialFileName & ""
- .Filters.Clear
- If filterTypes <> "" Then
- .Filters.Add filterName, filterTypes
- End If
- .Filters.Add "All Files", "*.*"
- If .Show = -1 Then
- FilePath = .SelectedItems(1)
- Set OpenXlsFile = Workbooks.Open(FilePath)
- End If
- End With
- End Function
复制代码 此函数用对话框打开Excel文件,可自定义打开对话框的标题,打开类型的筛选和起始路径.如图:
测试代码:- Sub test()
- Dim Xls As Workbook
- Set Xls = OpenXlsFile("随便打开个文件", "我的文件", "*.xls,*.xlsm", "C:")
- If Not Xls Is Nothing Then
- MsgBox Xls.Name '获取打开文件的名字
- MsgBox Xls.Path '获取打开的文件路径
- Xls.Close False '关闭文件
- End If
- End Sub
复制代码
Upload.zip
(17.89 KB, 下载次数: 13)
|
|