View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_29_] Bill[_29_] is offline
external usenet poster
 
Posts: 3
Default Automatically Parsing Fixed-width Text Import

I want to automate this function for a daily feed of a text file with fixed
width fields. Ther are about thirty column breaks to select and this would
be a real pain to have to do every day. I know I can record a macro, but I
want to start the process after the File Open dialog. My VBA skills are
effectively non-existent but if I had some code I could probably modify it
to my needs. Can someone please point me in the right direction. .