|
發表於 2017/6/30 11:43:06
|
顯示全部樓層
我有一樣的要求,所以之前就有試著修改代碼並且成功,用的參考正是悶哥的連結。
請注意除樓主貼圖的Sub以外,其他的如Sub BrowseDialog、Sub ISOJPGNOSAVE、Sub 自動插入圖片...也需修改。
看了一下要改的地方還真不少!我拋個磚,看樓主是不是有興趣自行研究一下~
- Sub ISOJPGSAVE()
- Dim swApp As Object
- Dim PathNames() As String
- Dim FileNames() As String
- HeaderRow = 2
- RowNumber = HeaderRow + 1
- Fcount = 0
- Set swApp = CreateObject("SldWorks.Application") '啟動SW
- Set Part = swApp.ActiveDoc
- If Not (Part Is Nothing) Then
- YN = MsgBox("Some files are still opened in SolidWorks, It may cause errors." & Chr(13) & "Press 'Yes' to Continue or press 'No' to close files then run again.", vbYesNo)
- If YN <> 6 Then
- Exit Sub
- End If
- End If
- PathName = Cells(RowNumber, 1)
- Filename = Cells(RowNumber, 2)
- ConfigName = Cells(RowNumber, 3)
- While Not (PathName = "" Or PathName = 0 Or IsEmpty(PathName)) '直到讀完路徑欄
- Set Part = swApp.OpenDoc(PathName & Filename, 1) '開啟零件
- Part.ShowNamedView2 "*Isometrisch", 7 '等軸測顯示
- Part.ViewZoomtofit2 '視角最大化
- sFilename = Left(Filename, Len(Filename) - 7) + ConfigName + ".jpg"
- longstatus = Part.SaveAs3(PathName & sFilename, 0, 0) '存為JPG文件
- Cells(RowNumber, 4) = sFilename '填寫JPG檔案名稱
- Part.Save '保存
- Cells(RowNumber, 2).Interior.Color = RGB(255, 200, 200) '保存單元格變色
- swApp.CloseDoc (PartFileName) '關閉零件
- Fcount = Fcount + 1
- RowNumber = RowNumber + 1 '下一列
- PathName = Cells(RowNumber, 1)
- Filename = Cells(RowNumber, 2)
- ConfigName = Cells(RowNumber, 3)
- Wend '回到>直到讀完路徑欄
- If Not swApp.Visible Then
- swApp.ExitApp
- End If
- MsgBox "已完成" & Fcount & "個JPG文件"
- End Sub
複製代碼
|
|