|
本帖最后由 fjmxwrs 于 2011-10-3 22:59 编辑
回复 studystudy 的帖子
- Sub Tqss()
- Dim arr(), x&, i&, j&, len_arr&
- Dim LineString As String
- Dim iFileNumber As Integer 'File number
- Dim openFileName, inputFileName As String
- iFileNumber = FreeFile '获得一个没有被使用过的文件编号
- openFileName = ThisWorkbook.Path & "\test.txt"
- Open openFileName For Input As #iFileNumber '打开文本文件
- len_arr = 1
- Do While Not EOF(1) '只要没有到文件末尾,就在文本文件内循环
- Line Input #1, LineString '读取文本文件一行数据
- LineString = Replace(LineString, " ", "") '用replace函数把" "处理掉
- ReDim Preserve arr(1 To (len_arr))
- arr(len_arr) = LineString
- len_arr = len_arr + 1
- Loop
- Close #iFileNumber '关闭文件
- inputFileName = ThisWorkbook.Path & "\result.txt"
- Open inputFileName For Output As #iFileNumber '创建新的文件或者覆盖已经存在的文件
- With Sheet1
- i = [a1] + 1
- j = [b1]
- For x = UBound(arr) To 1 Step -i
- j1 = j1 + 1
- If j1 <= j Then
- Print #iFileNumber, arr(x)
- End If
- Next x
- End With
- Close #iFileNumber '关闭文件
- End Sub
复制代码
help_1001.zip
(11.93 KB, 下载次数: 2)
|
|