Public Sub OutDataToExcel(Flex As SSDBGrid) '导出至Excel
Dim sValue 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
With Flex
k = .Rows
For i = 0 To k - 1
For j = 0 To 4
' DoEvents
sValue = "'" & .Columns(j).Value
Excelapp.ActiveSheet.Cells(i, j + 1) = sValue
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
当有10行记录时,上面这段语句只能将指针所在处的行导10边。指针不会下移。如何解决。
Dim sValue 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
With Flex
k = .Rows
For i = 0 To k - 1
For j = 0 To 4
' DoEvents
sValue = "'" & .Columns(j).Value
Excelapp.ActiveSheet.Cells(i, j + 1) = sValue
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
当有10行记录时,上面这段语句只能将指针所在处的行导10边。指针不会下移。如何解决。
解决方案 »
- ListView中如何给汉字排序?
- 我的Form_KeyPress事件为何有时没办法响应呢?分不够再加!加到大家满意!只是要解决问题!
- 各位高手谁会ADO控件联接网上局域的ACCESS数据库啊 (在线等了)分不够再加了
- 申请id成功,散100分庆祝!
- 消息框问题!
- 十万火急!急需帮助!以身相许!!
- 如何用listimage 加载资源文件中的多个位图
- 请问如何将FORM左上角的图标弄没?
- ★★★★★★旧题重提★★★★★★,还有人会吗??
- 关于数据库的合理设计思路
- 作了安装程序后,xp系统安装的时候提示为什么TABCTL32.ocx为无效的映象,98系统安装没什么问题已经打了sp5补丁,怎么解决?
- 如何让程序不在任务栏中显示但在ctrl+tab中显示出来
'請你自己加個CommonDialog控件
Private Sub Command3_Click()
Dim objFileSystem As Object
Dim objExcelText As Object
Dim strTableString As String, i As Integer, strFileName As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strConn As String
Dim strSQL As String strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerNmae"
pubConn.Open strConn
rsTable.CursorLocation = adUseClient
strSQL = "select top 10 * from gate_register"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
For i = 0 To rsTable.Fields.Count - 1
strTableString = strTableString & rsTable.Fields(i).Name & Chr(9) '獲取字段名
Next
strTableString = strTableString & rsTable.GetString '字段名+數據庫的記錄
cmDialog.CancelError = False
cmDialog.FileName = "FileName" '默認生成的文件名
cmDialog.DialogTitle = "Save Export File"
cmDialog.Filter = "Excel (*.xls)|*.xls|文本文件(*.DBF)|*.DBF|檔案文件(*.doc)|*.doc|所有文件(*.*)|*.*"
cmDialog.DefaultExt = "*.xls"
cmDialog.ShowSave
strFileName = cmDialog.FileName
Set objFileSystem = CreateObject("Scripting.FileSystemObject")
Set objExcelText = objFileSystem.createtextfile(strFileName, True)
objExcelText.writeline (strTableString)
objExcelText.Close
Set objFileSystem = Nothing
End Sub