Thread: Excel VBA help: Text file formatting
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Nila Nila is offline
external usenet poster
  
Posts: 7
Default Excel VBA help: Text file formatting
On Tuesday, June 10, 2014 9:40:11 PM UTC-6, GS wrote:
Oops! Change this...



ReDim saDataOut(1 To UBound(vData) + 2, 1 To MaxCols)



TO



ReDim saDataOut(1 To UBound(vData) + 1, 1 To MaxCols)



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

Thank you Garry. I have it working. But the excel is not producing data after 34,000 lines. I believe it is not reading larger text files completely. How can I change the code to read large text files?
Reply With QuoteReply With Quote