循环执行下列代码有时会在 .Refresh BackgroundQuery:=False一句提示内存溢出,有时候又不会,请问该如何更改,谢谢。output.txt是个1Kb的小文本文件。
Private Sub 读取txt(shnm As String) 'shnm表示读取的txt输出到的工作表sheet的名字,输入到V列
Sheets(shnm).Select
Sheets(shnm).range("V:X").ClearContents
Set st = ActiveSheet.QueryTables.Add(Connection:="TEXT;E:\JAVA\WordSeg\file\output.txt", Destination:=range("$" & "V" & "$1"))
With st
.RefreshStyle = xlOverwriteCells 'xlInsertDeleteCells
.AdjustColumnWidth = False
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 65001
.TextFileOtherDelimiter = "/"
.TextFileColumnDataTypes = Array(2, 2, 1) '用于指定类型
.Refresh BackgroundQuery:=False
End With
Set st = Nothing
End Sub