Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Range("B2").Value <> "" Then
With Workbooks.Open("D:\标签数据\标签数据.xlsm")
ThisWorkbook.Sheets(1).Range("A2:O2").Copy .Sheets("标签数据").Range("A65536").End(3)(2)
.Close True
End With
End If
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Range("B2").Value <> "" Then
With Workbooks.Open("D:\标签数据\标签数据.xlsm")
ThisWorkbook.Sheets(1).Range("A2:O2").Copy .Sheets("标签数据").Range("A65536").End(3)(2)
.Close True
End With
End If
End Sub