Dim Items() As String
dim sItem as long
dim sData as string
dim i as long,j as long,k as long
dim sOut() as string
dim n as long
sData="文本数据内容"
sitems=split(sdata,vbcrlf)
n=ubound(sitems)
redim sOut(n\400)
for i=0 to n step 400
for k=0 to 399
if i+k>n then exit for '最后部分可能没有400个
sitem=sitem & sItems(i+k)
next
sout(k)=sitem
k=k+1
sitem=""
next
循环。
Dim Lines() As String
Lines = textFileContent.Split(VbCrLf)
Dim parts(0 To Lines \ 400) As String
For i = 0 To Ubound(parts)
For j = 0 To 400
parts(i) = parts(i) & VbCrLf & Lines(i * 400 + j)
Next
Next