If Tables("加工收发明细").current("单据状态")="已审核"
DataTables("加工收发明细").ReplaceFor("打印标志","已打印")
Dim Book As New XLS.Book(ProjectPath & "Attachments\横机回收单.xls")
Dim fl As String = ProjectPath & "Reports\横机回收单.xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(5,1).Value ="<加工收发明细,-12>"
Book.Build()
Book.Save(fl)
Dim App As New MSExcel.Application
App.Visible = False
App.Caption = "汉思软件"
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
App.Visible = True
Ws.PrintPreview
App.Quit
Else
messagebox.show("已审核的单据才能打印!","信息提示",MessageBoxButtons.ok, MessageBoxIcon.warning)
Return
End If
我的代码如下 红色代码不起作用
加好友 
发短信
Post By：2025/3/1 15:24:00 [只看该作者]
此主题相关图片如下：1.png