下面是代码,我是个新手,在网上下载来的代码,改过后就是不能打印,出错,请高手帮我看看,还要改哪,或要加什么?感觉没有跟DataGrid1绑定在一起啊,改好马上给分
Sub daying2()
'利用excel打印的例子
'首先 , 你必须建立一个excel的模板nex.xls, 放入程序下面的新建的目录report中
'工程--->引用--->microsoft excel 9.0
On Error Resume Next
'把查询到的数据放到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) - (Exl.Rows - 3) > 0
PageNum = PageNum + 1
Wend
'循环打印每一页
For P = 1 To PageNum
Dim Exl1 As New Excel.Application
Dim Book As Excel.Workbook
Dim Sheet As Excel.Worksheet
FileCopy App.Path & "\report\new.xls", App.Path & "\new.xls"
File = App.Path & "\new.xls"
Set Book = Exl1.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) = Exl.TextMatrix((P - 1) * Size + 2 + R, i - 1) 'cells为格子
Next
Next
.PageSetup.Orientation = xlLandscape
.PrintOut
End With
Book.Save
Book.Close
Set Book = Nothing
Exl.Quit
Set Exl = Nothing
Next
End Sub
Sub daying2()
'利用excel打印的例子
'首先 , 你必须建立一个excel的模板nex.xls, 放入程序下面的新建的目录report中
'工程--->引用--->microsoft excel 9.0
On Error Resume Next
'把查询到的数据放到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) - (Exl.Rows - 3) > 0
PageNum = PageNum + 1
Wend
'循环打印每一页
For P = 1 To PageNum
Dim Exl1 As New Excel.Application
Dim Book As Excel.Workbook
Dim Sheet As Excel.Worksheet
FileCopy App.Path & "\report\new.xls", App.Path & "\new.xls"
File = App.Path & "\new.xls"
Set Book = Exl1.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) = Exl.TextMatrix((P - 1) * Size + 2 + R, i - 1) 'cells为格子
Next
Next
.PageSetup.Orientation = xlLandscape
.PrintOut
End With
Book.Save
Book.Close
Set Book = Nothing
Exl.Quit
Set Exl = Nothing
Next
End Sub
解决方案 »
- Return String.IsNullOrEmpty(xmlVal) Or xmlVal = "*",求代码意思
- 将datagrid中记录导出到EXECL时出错!
- 高难度,怎样增加listview垂直滚动条的宽度
- 有关图按sin函数移到的问题
- 问个VB脚本问题
- 关于WORD和EXCEL的两个问题,高分求救!!!
- 我把我所有的分数都给你们!请高手们再帮帮我!
- 有关VB6 Interop UserControl COM在C++中调用
- VB6的一个类模块中的句子,VB5识别不出来,谁能帮我翻译成VB5吗?
- 为什么会出现“类不支持自动化(错误 430)”
- 如何使用CreatePipe函数来映射cmd.exe?50分
- 求按行读文本文件,把每行左空格去掉,然后一行行写入另一格文本文件的控制台下程序,越简单越好。。。。。
//Exl是什么?看样子象MSHFlexGrid