Saving an excel in tab delimeted text adding two new columns in the .txt file

Hi friends,

I have my client's data in a excel sheet (Account reference,Payment reference,Debtor Name,Amount,Cheque,New Balance .. etc)
Now i have to save them in a tab delimited text file having four columns Payment reference,Round number,Week ending dateand Amount.
This seems OK.. But then I have to add another two columns in the output text file (Round number and Week ending date) which arestored as a header in the excel sheet.

The input(1st line is header):-

Round No: 1040 Week ending: 4/21/2009
Account reference Payment reference Debtor Name Amount
004006978750 004006978750 XYZ $11.11

The required Output :-

Payment reference Round number Week ending date Amount
004006978750 1040 4/21/2009 $11.11

I need to know how to add these two columns in the text file (by extracting it from header).

I am able to store the excel sheet in the following way

Payment reference Amount
004006978750 $11.11

This should be done using VB macro..