“内存不足错误”在TextFileColumnDataTypes上 [英] "Out of memory error" on TextFileColumnDataTypes
问题描述
我有一个加载CSV文件的工作宏。
设置conData = Application.ActiveWorkbook.Connections(" ...")。TextConnection
conData.Connection = ...
$
如果我尝试强制执行列格式,使用下一行,它会停止(在此行上) )消息"Out of memory error"。
$
conData.TextFileColumnDataTypes = Array(xlTextFormat)
有什么想法吗?它仍然没有开始读取文件。我甚至试图在"Set conData = ..."之后把这条线放好。 line
感谢您的帮助
PS:我在Office365中
I have a working macro that load a CSV file.
Set conData = Application.ActiveWorkbook.Connections("...").TextConnection
conData.Connection = ...
If I try to enforce a column format, with the next line, it stops (on this line) with the message "Out of memory error".
conData.TextFileColumnDataTypes = Array(xlTextFormat)
Any idea? It still did not begin to read the file. I even tried to put this line right after the "Set conData = ..." line
Thanks for any help
PS: I'm in Office365
这篇关于“内存不足错误”在TextFileColumnDataTypes上的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!