ds-blue-logo
Preview  |  SOLIDWORKS USER FORUM
Use your SOLIDWORKS ID or 3DEXPERIENCE ID to log in.
JDJames Dickson31/03/2020

I have a macro that will copy the notes from the format sheet and paste them on the front sheet. Everything works great except I cant figure out how to clear the copied notes from the clipboard. If I run the macro again and there are no notes on the format sheet it will paste the note from the last notes copied. 

Is there a way to clear the copy clipboard or if there are no notes then do skip the paste.

Part of the code below. Thanks for any help you can give.

Private Sub CommandButton_Move_Notes_Click()

Dim swApp As Object

Dim Part As Object
Dim boolstatus As Boolean
Dim longstatus As Long, longwarnings As Long

Set swApp = Application.SldWorks

Set Part = swApp.ActiveDoc


If Update_Format.ComboBoxCurrentSheetSize.Value = "" Then

MsgBox "Select Currnt Sheet Size Before Performing Action"

Else

If Update_Format.ComboBoxCurrentSheetSize.Value = "DONE" Then

MsgBox "Select A New Currnt Sheet Size Before Performing Action"

Else

If Update_Format.ComboBoxCurrentSheetSize.Value = "B" Then

boolstatus = Part.Extension.SelectByID2(" A", "SHEET", 0.104339414046694, 0.175981350443167, 0, False, 0, Nothing, 0)

Part.EditTemplate
Part.EditSketch
Part.ClearSelection2 True

boolstatus = Part.Extension.SelectByID2("Sheet Format1", "SHEET", 0.138783928127944, 8.60099041792129E-02, 0, False, 0, Nothing, 0)
boolstatus = Part.Extension.SketchBoxSelect("0.138784", "0.086010", "0.000000", "0.009617", "0.262687", "0.000000")

Part.EditCopy
Part.EditDelete

boolstatus = Part.Extension.SelectByID2("Sheet Format1", "SHEET", 9.61700032325701E-03, 0.262686506578727, 0, False, 0, Nothing, 0)

Part.EditSheet
Part.EditSketch
Part.ClearSelection2 True

boolstatus = Part.Extension.SelectByID2(" A", "SHEET", 1.11016776543454E-02, 0.261201829247639, 0, False, 0, Nothing, 0)

Part.Paste

Part.ClearSelection2 True

ComboBoxCurrentSheetSize.Value = "DONE"

End If

End Sub