View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rachel Rachel is offline
external usenet poster
 
Posts: 113
Default import text w/macro

I've tried recording a macro that will open a text file into Excel 2003. The
text file has over 256 columns, so while recording the macro i set some
columns to be "skipped" (not imported). When i clicked "finish", i got an
error message about "Too many line continuations".

The text file did open fine, but when i looked at the recorded macro in VBA,
the code was in red and was clearly cut off after a certain point.

Is there a way i can write code/record a macro to open this text file
(again, i just want to import some of the 256+ columns) that won't run into
the "Too many line continuations" problem?

Thanks
rachael