Foxtable(狐表)用户栏目专家坐堂 → 请指教


  共有2172人关注过本帖平板打印复制链接

主题:请指教

帅哥哟,离线,有人找我吗?
nxqtxwz
  1楼 | QQ | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:六尾狐 帖子:1492 积分:12149 威望:0 精华:0 注册:2013/3/19 16:41:00
请指教  发帖心情 Post By:2020/6/29 15:38:00 [只看该作者]

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()


 回到顶部
总数 15 1 2 下一页