Tables("收购").Current("作废") = True
Tables("收购").Current("编号") = Tables("收购").Current("编号") & "-" & "已作废"
If Functions.Execute("net20sp1") = False Then
Return
End If
Dim Book As New XLS.Book(ProjectPath & "Attachments\作废收购单.xls")
Dim fl As String = ProjectPath & "Reports\作废收购单.xls"
Book.Build()
Book.Save(fl)
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Ws.PrintOut
App.Quit
Tables("收购").Current.Clone()
加后缀位置不对,如何修改?