Attached is a master utility an expert has built for me to speed up modifying original source report data into a usable form. The button named ' import and parse purchase order status report' is used to parse weekly spend reports showing weekly spend by supplier.
I have had no problems with it until recently. For some reason the attached txt. file '30.06.14.txt.' is failing when importing it into the utility.
Can anyone tell me why or even better fix the error?(I have know macro or code writing experience!) I have attached two other weekly spend txt. files that work correctly so you know what the end result should look like