OK, Is the file always named the same? If not, then copy it locally, and name it SHAREPOINTINPUT.
Now, open up a new workbook, and click on Data>import from text.
When it asks how is the file formatted, select "SET FIELD LENGTHS". In th enext screen set up the string with 9 character delimiters. Save it.
Now, work the data. Save it as something else.
Now, when you get a new file, name it the same, place it in th esame directory, open up the workbook, and hit F9 (refresh data).
Post back if you have different specifications (I expect the scope will expand!)