得到EXCEL批注.txt

   Dim I As Integer
        If CurSheet.Comments.Count < 1 Then
            Exit Sub
        End If
        Dim CurRange As Excel.Range
        For I = 1 To CurSheet.Comments.Count
            Dim TempComment As String = ""
            TempComment = CurSheet.Comments.Item(I).Text
            If TempComment.Trim <> "" Then
                CurSheet.Comments.Item(I).Parent.Select()
                CurRange = CurExcel.ActiveCell
                CheckComment(TempComment, CurSheet, CurRange)
            End If
        Next

posted on 2006-07-04 18:15  Sanle  阅读(295)  评论(0编辑  收藏  举报

导航