Sub 按钮5_单击()
Private Sub cmdNewOrder_Click()
Dim r As Long
r = Range("J2")
If Range("B" & r) = "" Then Exit Sub
′用当前行的数据新建订单
Dim oAdd As Object
oAdd = Application.COMAddIns("ESClient.Connect").Object
oAdd.addInitData "客户编号", Range("B" & r)
oAdd.addInitData "客户名称", Range("C" & r)
oAdd.addInitData "发货地址", Range("D" & r)
oAdd.addInitData "办公电话", Range("E" & r)
oAdd.newReport "订单"
oAdd = Nothing
End Sub