Code:
Public Sub ConnectToAcad()'vorher noch Abfrage, ob das Dokument bereits erstellt wurde
Dim fso As FileSystemObject
Dim acadApp As Object
Set fso = New FileSystemObject
Set acadApp = Nothing
If fso.FileExists("C:\tmp\test\1-250.zip") Then 'Den Pfad anpassen
MsgBox "ZIP vorhanden"
GoTo ende:
End If
On Error GoTo error
Set acadApp = GetObject(, "AutoCad.Application")
MsgBox "Bitte beenden Sie AutoCAD und probieren es erneut !"
GoTo ende:
error:
If Err.Number = 429 Then
Set acadApp = CreateObject("AutoCAD.Application")
acadApp.Application.WindowState = acMin
'acadApp.Application.Visible = False
End If
acadApp.Documents.Open ("C:\tmp\test\1-250.dwg") 'Den Pfad anpassen
Call acadApp.ActiveDocument.SetVariable("Filedia", 0)
acadApp.ActiveDocument.SendCommand ("-etransmit" & vbCr & "zip" & vbCr & "C:\tmp\test\1-250" & vbCr _
& vbCr & "j" & vbCr & "n" & vbCr & "n" & vbCr & "j" & vbCr & "n" & vbCr & vbCr)
Call acadApp.ActiveDocument.SetVariable("Filedia", 1)
acadApp.ActiveDocument.Close
acadApp.Quit
ende:
Set fso = Nothing
Set acadApp = Nothing
End Sub