A client of mine has asked me to process some data from a text file.
The file will be received on a weekly basis and will always have the
same parameters (see below). I would like to know if it would be
possible to automate this process without manually picking the start
and end locations on the text conversion wizard within Excel. I'm not
great with VB but it seems like this could be done with a macro of some
kind? If anyone can lend some insight, it would be greatly appreciated.
Thank you.

START END LENGTH
1 8 08
9 19 11
20 49 30
50 50 01
51 80 30
81 81 01
82 111 30
112 141 30
142 171 30
172 173 02
174 178 05
179 183 05
184 193 10
194 203 10
204 212 09
213 221 09
222 230 09
231 239 09
240 248 09
249 257 09
258 266 09
267 275 09
276 284 09
285 293 09
294 295 02
296 297 02
298 299 02
300 301 02