我用MSFlexGrid 控件绑定Data控件来操作数据库,如何能实现数据打印呢。在VB里怎么能打印出word 文档呢。请帮忙!!
解决方案 »
- 各位大哥,哪里有瑞星注册机下载呀!
- 各位大侠,如何定义数组,可以在不同窗体间调用???急!!!!!!!!!!!!!!!!!!!!马上送分
- 难难难,vb怎么调用access 里面的摸块函数,请高手指教
- 数据库连接问题
- 谁做过mshflexgrid能展开和收缩的案例,跪求!!!
- 基于 Excel 的 VBA 程序设计开发,怎么操作呢?????求助
- 如何立即更新水晶报表中的数据库?关于水晶报表高分(100)
- 用SDK5.1已经能说中英文,如何让Agent说中文?
- 用VB做安装程序需要有那些步骤?
- 如何调用调用以知的dll文件中的函数?
- VB数据库记录删除问题
- 我玩玩了,大家快来救我吧!不来救我我真的要自杀了.
'把查询到的数据放到excel中打印
Dim PageNum As Integer
Dim Size As Integer
Dim File As String
Dim I As Integer
Dim R As Integer
Dim P As Integer
PageNum = 1 '打印的页数
Size = 17 '一页可以打印的行数
'得到打印的页数
While Not (PageNum * Size) - (Msf.Rows - 3) > 0
PageNum = PageNum + 1
Wend'循环打印每一页
For P = 1 To PageNum
Dim Exl As New Excel.Application
Dim Book As Excel.Workbook
Dim Sheet As Excel.Worksheet
FileCopy App.path & "\report\xx.xls", App.path & "\xx.xls"
File = App.path & "\xx.xls"
Set Book = Exl.Workbooks.Open(File)
Set Sheet = Book.Worksheets(2)
Book.Application.DisplayAlerts = False '把数据写入sheet中
With Sheet
For R = 1 To Size
For I = 1 To 12
.Cells(R + 5, I) = Msf.TextMatrix((P - 1) * Size + 2 + R, I - 1)
Next
Next
.PageSetup.Orientation = xlLandscape .PrintOut
End With
Book.Save
Book.Close
Set Book = Nothing
Exl.Quit
Set Exl = Nothing
Next
Dim dc As New Word.Document
'打开你的word文档
dc.Application.DisplayAlerts = wdAlertsAll
Set dc = wd.Documents.Open("c:\123.doc")
With dc
'插入一个2行5列的表格
.Tables.Add Range:=Selection.Range, NumRows:=2, NumColumns:= _
5, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:= _
wdAutoFitFixed
'在第一行,第一列中填入数据 1
Selection.TypeText Text:="1"
'格子间的移动
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.MoveDown Unit:=wdLine, Count:=1
Selection.MoveRight Unit:=wdCharacter, Count:=5
Selection.MoveLeft Unit:=wdCharacter, Count:=1
'增加一行
Selection.InsertRows 1
End With
'打印
dc.PrintOutdc.Save
dc.Close
Set dc = Nothing
wd.Quit
工程->引用->Microsoft Word 9.0 Object Library(后面为版本号)至于怎么控制,你可以上WORD中录制宏看一下就知道了!