View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default HowDoI Convert Excel to Tab Delim txt (File to long to open in Exc

Have you considered a low tech solution like splitting the file up into
shorter files?

--
Jim
"MikeZz" wrote in message
...
| Hi,
| I get an excel file that may have more than the 65k line max in Excel03.
| I was wondering if there was a utility or plugin that would allow me to
| bring it into an array through vba so I can do all the calculations
because
| the finished file would fall within the limit.
|
| I'm also open to a 3rd party file converter but I need to have it convert
to
| Tab Deliminated Text because the data itself has commas and other special
| characters in them.
|
| Thanks for any help!
|
| MikeZz