View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajocius[_51_] ajocius[_51_] is offline
external usenet poster
 
Posts: 1
Default VBA - 300 Columns Of Text


Group,

How do I open a .dat file that is essentially a text file with
about 300 columns (comma delimited) of data. When I attempt to open
the file with Excel, I get only the first 254 columns and the rest is
dropped. I'm willing to put the remaining 60 some columns on another
sheet. How would I do that in VBA. Any help would be great.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=512064