|
在SW中,如果采用VBA选择文件,可以用函数GetOpenFileName来选择文件,但该函数只支持单选一个文件,不支持选择多个文件。- Dim Filter As String
- Dim fileName As String
- Dim fileConfig As String
- Dim fileDispName As String
- Dim fileOptions As Long
- Private Sub CommandButton1_Click()
- Filter = "SolidWorks Files (*.sldprt; *.sldasm; *.slddrw)|*.sldprt;*.sldasm;*.slddrw|Filter name (*.fil)|*.fil|All Files (*.*)|*.*|"
-
- fileName = swApp.GetOpenFileName("File to Attach", "", Filter, fileOptions, fileConfig, fileDispName)
- Debug.Print fileName
- End Sub
复制代码
那么,如果同时选择多个文件怎么办呢?
通过查找资料及自己的摸索,终于找到了解决这个问题的办法。
1.如果电脑安装了office相关软件,可以借助office的控件;- Option Explicit
- Dim swApp As Object
- Dim fileName As Variant
- Dim xlapp As Object
- Dim i As Long
- Sub main()
- Dim strFilter As String
- On Error Resume Next
-
- Set swApp = CreateObject("SldWorks.Application")
- Set xlapp = CreateObject("Excel.Application")
-
- strFilter = "SolidWorks文件 ,*.sldprt;*.sldasm;*.slddrw"
- fileName = xlapp.GetOpenFileName(strFilter, , Title:="选择SolidWorks文件...", MultiSelect:=True)
- Set xlapp = Nothing
-
- If IsArray(fileName) Then
- For i = LBound(fileName) To UBound(fileName)
- Debug.Print fileName(i)
- Next i
- End If
- End Sub
复制代码 运行程序后,等对话框弹出后,可通过ctrl+A,ctrl+右键,shift+右键,等方式选择多个文件
利用Office控件多选方式选择文件
2.通过API函数,选择多个文件
打开多选文件对话框(2).zip
(30.7 KB, 下载次数: 188, 售价: 30 金币)
|
评分
-
查看全部评分
|