Foxtable(狐表)用户栏目专家坐堂 → [求助]狐之爸:分组打印按钮的问题还是没有解决呀


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

主题:[求助]狐之爸:分组打印按钮的问题还是没有解决呀

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


加好友 发短信 小学文化
等级:小狐 帖子:374 积分:2318 威望:0 精华:0 注册:2008/12/6 20:34:00
  发帖心情 Post By:2009/3/15 22:47:00 [只看该作者]

Dim Arys As List(Of String())
Arys = DataTables("当月在职工资表").GetUniqueValues("", "所在单位","所在部门")
For Each Ary As String() In Arys
With Tables("当月在职工资表")
.Filter = "[是否停发] = False And [所在单位] = '" & Ary(0) & "' And [所在部门] = '" & Ary(1) & "'"
If .Rows.Count = 0 then
Continue for
End If
.Select(0,0,.Rows.Count -1,.Cols.Count -1)
Dim Book As New XLS.Book(ProjectPath & "Attachments\工资.xls")
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Book.Build()
Book.Save(ProjectPath & "Reports\工资.xls")
Dim Proc As New Process
Proc.File = ProjectPath & "Reports\工资.xls"
proc.Verb = "Print"
Proc.Start()
End With
Next
Tables("当月在职工资表").Filter = ""


谢谢狐他爸的最新代码,问题已解决

可我不明白最后的一句代码作用? Tables("当月在职工资表").Filter = ""

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