Dim Book As New XLS.Book(ProjectPath & "Attachments\晨午检上报表.xlsx")
Dim fl As String = ProjectPath & "晨午检报表\" & "晨午检上报表" & Date.today & ".xlsx" 想把Date.today 改成表中的“日期”字段怎么改呢。
'Dim fl As String = ProjectPath & "Reports\晨午检上报表.xlsx"
For Each r As Row In Tables("晨午检").GetCheckedRows
s =s & "," & r("_Identify")
Next
s = s.Trim(",")
Tables("晨午检").Filter = "[_Identify] in (" & s & ")"
Book.Build() '生成细节区
Dim Proc As New Process '打开工作簿
Proc.File = fl
'Proc.Verb = "Print" '指定动作
Proc.Start()