将MsFlexGrid控件的内容输出到文本

发表于:2007-06-21来源:作者:点击数: 标签:
'OutDataToText '将MsFlexGrid控件中显示的内容输出到文本文件 Public Sub OutDataToText(Flex As MSF lexGrid) Dim s As String Dim i As Integer Dim j As Integer Dim k As Integer Dim strTemp As String On Error GoTo Ert Me.MousePointer = 11 On Err

     'OutDataToText
  '将MsFlexGrid控件中显示的内容输出到文本文件
  Public Sub OutDataToText(Flex As MSFlexGrid) 
    Dim s As String
    Dim i As Integer
    Dim j As Integer

    Dim k As Integer
    Dim strTemp As String
    On Error GoTo Ert
    Me.MousePointer = 11
    On Error Resume Next
    DoEvents
    Dim FileNum As Integer
    FileNum = FreeFile
    Open "d:\aa.txt" For Output As #FileNum
        With Flex
            k = .Rows
            For i = 0 To k - 1
                strTemp = ""
                For j = 0 To .Cols - 1
                    DoEvents
                    strTemp = strTemp & .TextMatrix(i, j) & ","
                Next j
                Print #FileNum, Left(strTemp, Len(strTemp) - 1)
            Next i
        End With
    Close #FileNum
    Me.MousePointer = 0
    MsgBox "导出成功"
  Ert:
    MsgBox Err.Description
    Me.MousePointer = 0
  End Sub


原文转自:http://www.ltesting.net