如果你指的打开是显示一个文件对话框,选择打开的文件的话。
可使用
1。使用OFFICE自身的文件对话框
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog(msoFileDialogOpen)
With dlgOpen
.AllowMultiSelect = True '你可加上其它设置
.Show
End With
2。微软自身的commondialog控件(可参照VB的书籍)
3。也可使用API GetOpenFileName来实现(有多种实现方法,可做成类库)
Private Declare Function GetOpenFileName Lib "COMDLG32" _
Alias "GetOpenFileNameA" (file As OPENFILENAME) As Long
Private Declare Function GetSaveFileName Lib "COMDLG32" _
Alias "GetSaveFileNameA" (file As OPENFILENAME) As Long