challenge - flat file creation

Ok I need to create a flat file to upload to our peoplesoft gl database. I have all the data in one tab and I know the placement and spacing of each data point. What I need is some method to create the flat file. I thought a VBA macro could do the trick but I'm not sure how to proceed. The following is an example of the flat file structure:
BJS001Budget_FSBudget_FS 2300 10 3452 112.20


Thanks in advance