solidworks的VBA问题

dajian1984 · 发表于 2023-4-21 22:34:46

我打的程序无法运行，有没有懂的人帮我看看！谢谢。

Dim swapp As Object
Dim part As Object
Dim boolstatus As Boolean
Dim longstatus As Long, longwarnings As Long
Dim pathstr As String
Dim fname(500) As String, fnum As Long
Sub main()
Dim i As Long
Dim pathstr0 As String, pathstr1 As String
Dim pathstr2 As String, pathstr3 As String, pathstr4 As String, pathstr5 As String
Dim L As Long, L1 As Long
pathstr = InputBox("请输入需要转的工程图所在位置")
Call Showfilelist(pathstr)
Set swapp = Application.SldWorks

For i = 0 To fnum - 1
pathstr0 = pathstr & "\" & fname(i)

Set part = swapp.OpenDoc6(pathstr0, 3, 0, "", longstatus, longwarnings)

L = Len(pathstr0)

pathstr1 = Left(pathstr0, L - 7) & ".DWG"

pathstr2 = Left(pathstr0, L - 7) & ".PDF"

longstatus = part.SaveAs3(pathstr1, 0, 0)

longstatus = part.SaveAs3(pathstr2, 0, 0)

Set part = Nothing

L1 = Len(fname(i))

pathstr3 = Left(fname(i), L1 - 7) & "- 图纸1"

pathstr4 = Left(fname(i), L1 - 7) & "- 图纸2"

pathstr5 = Left(fname(i), L1 - 7) & "- 图纸3"

swapp.colsedoc pathstr3

swapp.colsedoc pathstr4

swapp.colsedoc pathstr5

Next i

End Sub

Private Sub Showfilelist(folderspec As String)

Dim fs, f, f1, fc, s

Set fs = CreateObject("scripting,filesystemobject")

Set f = fs.getfolder(folderspec)

Set fc = f.files

fnum = 0

For Each fi In fc

If InStr(f1.Name, "slddrw") > 0 Then

fname(fnum) = f1.Name

fnum = fnum + 1

End If

Next

End Sub

steve_suich · 发表于 2023-4-25 09:06:09

Dim swapp As Object, C: K( B9 r2 b1 R/ J1 @4 {5 @- O
Dim part As Object
7 `2 b( @9 Y& J, j$ l3 }- w( O
Dim boolstatus As Boolean+ @1 t: p. b' i2 {" e) Y
Dim longstatus As Long, longwarnings As Longu: z/ l, D1 r# Y0 B; i+ R' v |
Dim pathstr As String
9 u E, O7 i: Z5 s+ X0 l8 p" z
Dim fname(500) As String, fnum As Long
1 w4 n0 ^/ t- U2 T1 w
Sub main()6 g( K+ n) }% H% f
Dim i As Long
8 N7 b; q2 F8 U w7 l% V1 a
Dim pathstr0 As String, pathstr1 As String2 y3 J, P# e- L: |; p0 O7 h
Dim pathstr2 As String, pathstr3 As String, pathstr4 As String, pathstr5 As String
0 J7 u( v5 b9 B3 a
Dim L As Long, L1 As Long2 g, R" T: u5 T O
pathstr = InputBox("请输入需要转换的工程图所在位置")% k+ t' v0 m- D
Call Showfilelist(pathstr)
: n# d+ ]2 G3 r# j5 a$ e1 W0 i3 x1 N
Set swapp = Application.SldWorks" c1 f& \; u" {; i5 Y' v0 ]0 ~
b- p) |0 ]7 \8 F% W8 M
For i = 0 To fnum - 1
q" V+ K% y* B
pathstr0 = pathstr & "" & fname(i)
' f+ s1 }4 D& N2 j' p
: u9 h% K9 O. F
Set part = swapp.OpenDoc6(pathstr0, 3, 0, "", longstatus, longwarnings)
, P( X$ M7 S' N
L = Len(pathstr0)
4 t. k8 L- S% v) N6 N
6 [' {0 f i b' f( W
pathstr1 = Left(pathstr0, L - 7) & ".DWG"+ n" e. B/ f- T' @
. a) c% `1 E1 W
pathstr2 = Left(pathstr0, L - 7) & ".PDF"0 M- @: K3 ~( g6 u7 X: @
5 k u8 C; V' y! A
longstatus = part.SaveAs3(pathstr1, 0, 0)- i& F4 D# s$ n
longstatus = part.SaveAs3(pathstr2, 0, 0)
6 s4 a4 O, E; }/ i6 P
% x* D2 D' ~/ v/ p: Z
swapp.CloseDoc pathstr06 O M6 E, E2 Q% m# ?' Z
% B' P7 C3 n) V. L# o6 f4 N
Next i& @& o& g# V H! v3 b: {
4 I3 K+ }( W; l' }
End Sub
: [. [) M$ W: i4 F6 J
6 S6 M- Q( s8 M$ U# D
Private Sub Showfilelist(folderspec As String)
# j. n# Q' H+ F0 z0 u' X3 K" D& t
Dim fs, f, f1, fc, s. ?. ^3 }* D- `2 L D) p4 U L
- ~0 Z# T7 c/ k% x/ R
Set fs = CreateObject("Scripting.filesystemobject")
1 X- ^# l3 C* I! a V
0 r7 Q2 L8 K# I& p' x+ ?6 b
Set f = fs.getfolder(folderspec)# w% Z, f8 T) o+ Q7 F! q" o% g
, t3 ?0 T8 A, K0 V. B: D; F ?" R. ?
Set fc = f.files
0 {* x! i6 I4 z) I$ l7 u8 z
0 n- J) f5 B7 z
fnum = 0
$ B: ?, P6 F ~ n+ H7 o; A) z3 W
: z. T, R7 ~: c3 z7 d+ x# F1 K6 U
For Each f1 In fc
z6 g) F+ G6 Q- y! G' B0 K
If InStr(UCase(f1.Name), "SLDDRW") > 0 Then
6 O* e7 ]' [4 e! l& x$ K& H2 O
fname(fnum) = f1.Name
5 g3 F: |+ e/ \5 C7 z9 {1 J
fnum = fnum + 1
8 o5 d' _% Q# `6 j
9 ]. E( [$ _5 i/ j ?
End If
8 h7 l) B; P Q1 A, v0 }
& x0 z4 g, L& j g2 m
Next% p) q4 H5 _0 N* ~) K' ]) r
: T8 U5 s0 u- U1 j' i
End Sub, B# ?7 Q. K7 s J& o! u

复制代码

steve_suich · 发表于 2023-4-25 09:07:53

本帖最后由 steve_suich 于 2023-4-25 09:10 编辑

swapp.colsedoc 应为swapp.closedoc
Scripting,filesystemobject应为Scripting.filesystemobject
判断slddrw时，应先全部转换为大写，再进行判断。

dajian1984 · 发表于 2023-4-25 09:35:37

steve_suich 发表于 2023-4-25 09:07
1 H& X4 J1 A" c3 e; A& eswapp.colsedoc 应为swapp.closedoc
0 w) d/ Z, j* P+ ?3 h9 }Scripting,filesystemobject应为Scripting.filesystemobject
' X) c- q! L( g3 g判断sld ...

谢谢。

		自动登录	找回密码
密码			注册会员