Private Sub Command12_Click() '生成xls
If MSFlexGrid1.TextMatrix(1, 0) = "" Then
MsgBox "没有生成内容!"
Else
Dim oExcel
Dim obook
Dim osheet
Dim jj As Integer
Dim ii As Integer
Set oExcel = GetObject(, "Excel.Application")
Set oExcel = CreateObject("Excel.Application")
oExcel.Visible = False
oExcel.ScreenUpdating = False
Set obook = oExcel.Workbooks.Add
Set osheet = obook.Worksheets(1)
For ii = 0 To MSFlexGrid1.Rows - 1
MSFlexGrid1.Row = ii
For jj = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.Col = jj
osheet.Range(Cells(ii + 3, jj + 1), Cells(ii + 3, jj + 1)).Select 'EXCEL文件有倆行表頭,而且是以第1行第一列開始計算,所以行加3而列加1
ActiveCell.FormulaR1C1 = MSFlexGrid1.Text
ActiveCell.ColumnWidth = 8.4
Next jj
Next ii
End If
End Sub执行进话我 子程序或涵数未定义!
If MSFlexGrid1.TextMatrix(1, 0) = "" Then
MsgBox "没有生成内容!"
Else
Dim oExcel
Dim obook
Dim osheet
Dim jj As Integer
Dim ii As Integer
Set oExcel = GetObject(, "Excel.Application")
Set oExcel = CreateObject("Excel.Application")
oExcel.Visible = False
oExcel.ScreenUpdating = False
Set obook = oExcel.Workbooks.Add
Set osheet = obook.Worksheets(1)
For ii = 0 To MSFlexGrid1.Rows - 1
MSFlexGrid1.Row = ii
For jj = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.Col = jj
osheet.Range(Cells(ii + 3, jj + 1), Cells(ii + 3, jj + 1)).Select 'EXCEL文件有倆行表頭,而且是以第1行第一列開始計算,所以行加3而列加1
ActiveCell.FormulaR1C1 = MSFlexGrid1.Text
ActiveCell.ColumnWidth = 8.4
Next jj
Next ii
End If
End Sub执行进话我 子程序或涵数未定义!
解决方案 »
- 如何立即隐藏驱动器
- 关于用代码实现对SQL数据库导入导出
- picturebox对流媒体的播放
- Setup Factory6.0 打包问题~
- 请教Dtpicker控件的问题
- 怎样判断当前操作系统是windows200 pro、win2000 server 或win200 adv server(注意,不是问怎样取得操作系统名)
- 传输问题(在线等,解决马上送分)
- 请来看看!谢谢!UPDATE SQL 怎样在ACCESS2K中使用?清指出错误:
- vb读取excel数据很奇怪的问题
- 菜鸟问题--Input()函数的问题
- 有没有可以躲避游戏服务器检测的 不会封号的 变速齿轮
- (求助)用vb识别音乐wav格式的节拍时间!!
Set oExcel = CreateObject("Excel.Application")
是不是写反了?
Set oExcel = CreateObject("Excel.Application")
是不是写反了?换过来试试
Set oExcel = CreateObject("Excel.Application")
Set oExcel = GetObject(, "Excel.Application")
但一定要在“引用”里引用microsoft excel *.* Object library(*.*是指安装的EXCEL 版本)
Public Sub ExpToExcel(lvwList As ListView)
Dim i As Long
Dim NewApp As New Excel.Application
Dim newBook As New Excel.Workbook
Dim NewSheet As New Excel.Worksheet
Set NewApp = New Excel.Application
Set newBook = NewApp.Workbooks.Add
Set NewSheet = newBook.Worksheets(1) If lvwList.ListItems.Count = 0 Then Exit Sub Dim arrData() As String
ReDim arrData(0 To lvwList.ListItems.Count, 0 To lvwList.ColumnHeaders.Count) As String
Dim j As Integer For j = 1 To lvwList.ColumnHeaders.Count
arrData(0, j - 1) = lvwList.ColumnHeaders(j).Text
Next For i = 1 To lvwList.ListItems.Count
arrData(i, 0) = lvwList.ListItems(i).Text
For j = 1 To lvwList.ColumnHeaders.Count - 1
arrData(i, j) = lvwList.ListItems(i).SubItems(j)
Next
Next
NewSheet.Range(NewSheet.Cells(1, 1), NewSheet.Cells(i, j)) = arrData
NewSheet.Columns.AutoFit
NewApp.Visible = True
Set NewSheet = Nothing
Set newBook = Nothing
Set NewApp = Nothing
End Sub