|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub yy()
Dim sr As String, fd As Boolean, l As Integer, i As Integer
Dim arr() As String, z As Integer
Range("a2:j10000").Clear
Open ThisWorkbook.Path & "\600017.txt" For Input As #1
Do While Not EOF(1)
Line Input #1, sr
If InStr(sr, "主力持仓统计") Then fd = True
If fd Then
If sr <> "" Then
If InStr(sr, "─") = 0 And InStr(sr, "━") = 0 Then
If InStr(sr, "【") Then
Range("a1") = sr
Else
l = l + 1
z = UBound(Split(sr, "│"))
ReDim Preserve arr(0 To z, 1 To l)
For i = 0 To z
arr(i, l) = Trim(Replace(Split(sr, "│")(i), "-", ""))
Next
End If
End If
Else
Exit Do
End If
End If
Loop
Close #1
Range("a2").Resize(UBound(arr, 2), z + 1) = Application.Transpose(arr)
End Sub
[ 本帖最后由 office2008 于 2009-4-30 18:02 编辑 ] |
|