我用下面的代码导出EXECL
Dim excelApp As Excel.Application
Set excelApp = New Excel.Application
On Error Resume Next
If excelApp Is Nothing Then
Set excelApp = CreateObject("Excel.application")
If excelApp Is Nothing Then
Exit Sub
End If
End If
excelApp.Visible = True
Me.MousePointer = vbHourglass
excelApp.Workbooks.Add
With excelApp.ActiveSheet
Dim i As Integer, j As Integer
For i = 1 To MSGrid.rows
For j = 1 To MSGrid.Cols
.Cells(i, j).Value = MSGrid.TextMatrix((i - 1), (j - 1))
Next j
DoEvents
Next i
End With
Me.MousePointer = vbDefault
Set excelApp = NothingEnd Sub
但我在mshflexgrid中有合并单元格时,导出到EXECL后,不能合并,请问如何解决??
Dim excelApp As Excel.Application
Set excelApp = New Excel.Application
On Error Resume Next
If excelApp Is Nothing Then
Set excelApp = CreateObject("Excel.application")
If excelApp Is Nothing Then
Exit Sub
End If
End If
excelApp.Visible = True
Me.MousePointer = vbHourglass
excelApp.Workbooks.Add
With excelApp.ActiveSheet
Dim i As Integer, j As Integer
For i = 1 To MSGrid.rows
For j = 1 To MSGrid.Cols
.Cells(i, j).Value = MSGrid.TextMatrix((i - 1), (j - 1))
Next j
DoEvents
Next i
End With
Me.MousePointer = vbDefault
Set excelApp = NothingEnd Sub
但我在mshflexgrid中有合并单元格时,导出到EXECL后,不能合并,请问如何解决??
解决方案 »
- 用VB可否实现如傲游浏览器拖放搜索高亮字的功能?
- 在VB或者在.net中如何用语句获取SQL服务器名称!急用!谢谢!
- listview控件问题,急
- 如何将本地数据库的SQL数据,移到局域网中一台计算机Access上?
- 想找人一起弄一个VB控件简单的ActiveX(送200分)
- 用installshield7.0+vb6.0打包,既不能uninstall,也不能用控制面板删除
- MP3播放列表的随机播放
- 小问题,那位帮忙看看呀,马上结贴
- 很急!用IF判断记录集的某个字段rs.fields("status")的值是否符合要求
- vb c++ dll 如何连接
- 从操旧业希望大家以后多多关照。
- 再问关于SQL语句
With excelApp.ActiveSheet
……
.Range(.Cells(startRow, startCol), .Cells(endRow, endCol)).Merge
……
End With