need macro to create pipe delimited text file from excel

hi,

anyone can help me to create pipe delimited text file from excel via macro?

attached is the excel source and output text file format.

the test file will have the following format:

|date|ID|WorkingDays|DaysPresent|AbsentHours|LateHours|PresentHours|

|yyyy-mm-dd|ID|13|12|0.00|0.00|96.00|


thanks,