Excel Macro to create Header and lines and save with Pipe CSV format

Hello,

i'm hoping someone can help with this code. i have a standard excel format file that has to be saved as *.csv with '|" pipe delimiter. also each record must have a header and line items. "H" for header and "I" .

please see sample attached. Please help.

thanks heaps.