View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan[_8_] Jan[_8_] is offline
external usenet poster
 
Posts: 5
Default Fixed Width - Opening Certain Fixed Width Files

I receive weekly data files from the USPS in a fixed
width format. Each file will have the exact same 23
fields defined when opened (position 1, 9, 16, 32, etc.).
Is there a way to create a macro that will automatically
parse the file at the correct 23 columns so this doesn't
have to be done manually each time I receive a new data
file?
Thanks,
Jan