Import Fixed Length File

I have one specific file that is generated by our student management system in a fixed-length format and I am regularly importing it to Excel to make manual changes to certain elements.

What I would like to do is automate the process of importing. Is there a way to have Excel grab this file, put the first character in column one and make the width of that column "1", put the next two characters into column 2 and make the width of column 2 "2", put the next 13 characters in column 3 and make the length "13", etc., etc.?

Can this be done with Visual Basic scripting?

Any assistance is appreciated.

Originally Posted by mudraker

You have not sais what type of file it is - Text, Csv etc

Have you tried recording a macro whilst importing (opening) the file?

It is basically a text file. I have not tried recording a macro. I certainly can give it a shot.

Worked like a champ.