View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucie Harris Lucie Harris is offline
external usenet poster
 
Posts: 1
Default Recording a macro to open a large fixed-width text file

On a monthly basis i am having to open a fixed width text file which
is nearly a thousand columns, as you can imagine this takes some time.
Elsewhere in the groups i found the suggestion to record a macro to
open the file, however when i reached the end i got the message "Too
many line continuations".

I am not a visual basic whizz, i'm limited to recording and running
macros, is there any way i can record this macro without getting this
message? any help would be appreciated.