窗体上有个mshflex空件;我想把空件里的数据写入到excel 中;并且打印出来!急啊;再线等!!!
解决方案 »
- 关于一个算法的问题
- 窗体Load事件中代码过多,造成窗体打开过慢,怎么解决?
- TO:绿豆大侠,有没有在Win98下对硬件启禁用的源码呢?
- 如何在vba中用datagrid阿??
- /*** 郁闷啊,关于VB编译EXE的奇怪的问题。***/
- 奇怪的问题, 在线等待
- 怎样使图标的背景透明?
- 请问,我今天在VB中使用Toolbar1控件时,为其中的每个工具按钮加入点击事件时,用Select Case Button.Key,它总是说“未找到方法或数据成
- 关于MDI窗体的问题
- VB 6.0 将在2008年"寿终正寝"
- crystal report中数据的格式,有没有类似format的函数?
- 如何备份sql数据库的某个表(vb)在线等,告急
'* 名称:OutDataToExcel
'* 功能:将MsFlexGrid控件中显示的内容输出到Excel表格中进行打印
'*********************************************************
Public Sub OutDataToExcel(Flex As MSFlexGrid) '导出至Excel
Dim s As String
Dim i As Integer
Dim j As Integer
Dim k As Integer
On Error GoTo Ert
Me.MousePointer = 11
Dim Excelapp As Excel.Application
Set Excelapp = New Excel.Application
On Error Resume Next
DoEvents
Excelapp.SheetsInNewWorkbook = 1
Excelapp.Workbooks.Add
Excelapp.ActiveSheet.Cells(1, 3) = s
Excelapp.Range("C1").Select
Excelapp.Selection.Font.FontStyle = "Bold"
Excelapp.Selection.Font.Size = 16
With Flex
k = .Rows
For i = 0 To k - 1
For j = 0 To .Cols - 1
DoEvents
Excelapp.ActiveSheet.Cells(3 + i, j + 1) = "'" & .TextMatrix(i, j)
Next j
Next i
End With
Me.MousePointer = 0
Excelapp.Visible = True
Excelapp.Sheets.PrintPreview
Ert:
If Not (Excelapp Is Nothing) Then
Excelapp.Quit
End If
End Sub
---------------------------------------------------------------
其他的语句上EXCEL中录制宏就知道了!!
'把查询到的数据放到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\new.xls", App.path & "\new.xls"
File = App.path & "\new.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
能不能不让客户看到excel;直接打印机打印出来啊
如果没有找到打印机的话怎么半呢