View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default Best way to import fixed-width delimited text files into an array?

Should I use the Workbooks.OpenText Filename, or is there a faster way to
bring in the file?

Actually, I may not even need the file in a worksheet, I just need the data
in an array so I can use it to manipulate an existing excel file...so would
it be faster to do some alternate type of file read directly into a
2-dimensional array?

Thanks for any advise,
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.