解决方案 »
- 关于EDB数据库的问题请教高手
- 请问VB的treeview控件是支持什么字符集的
- 怎么把日期转成UNIX 时间戳型式? 如(1109001909445这样的时间戳转换为类似2004-2-22 10:45:53秒
- 我安装一个用VB开发的程序后,运行时出现"430 类不支持自动化"这该怎么解决??
- 如何安装msdn
- 好习惯
- 如何备份sql server
- 请问一个简单得问题
- y1g1y1来领分,谢谢你的DLL和无错代码。给你200分(1)
- 请教各位大哥,如何的到本地的计算机名(不用ip地址)。
- QBASIC怎么判断文件是否存在
- Visual Studio 2013中如何在Picturebox中画出的图形缩放居中
private Sub Export()
Dim xlApp As Object 'Excel.Application
Dim xlBook As Object 'Excel.Workbook
Dim xlSheet As Object 'Excel.Worksheet Screen.MousePointer = vbHourglass
On Error GoTo Err_Proc
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1) 'Begin to fill data to sheet
Dim i As Long
Dim j As Integer
With FormName.Controls(flexgridname)
For i = 0 To .rows - 1
For j = 0 To .Cols - 1
xlSheet.Cells(i + 1, j + 1).Value = "'" & .TextMatrix(i, j)
Next j
Next i
End With
xlApp.Visible = True
Screen.MousePointer = vbDefault
Exit Sub
Err_Proc:
Screen.MousePointer = vbDefault
MsgBox "输出失败,错误原因为:" & Err.Description, vbExclamation, "提示"
End Sub