Help! create a PSV file using macros

[mrexcel1716]

dear Excel guru's

I have small requirement, i need to create a PSV file ( Pipe seperated file). looking for a macro which will generate Output with PSV

Filed 1	Filed 2	Filed 3	Filed 4	Filed 5	Filed 6	Filed 7	Filed 8	Filed 9
a	b	c	d	e	f	g	h	i
1	2	3	4	5	6	7	8	9
ab1	ab2	ab3	ab4	ab5	ab6	ab7	ab8	ab9
Last line in the table TOTAL NUMBER OF CONSUMER RECORDS IS 000000000&Count of records

<colgroup><col span="9"></colgroup><tbody>
</tbody>

Output should be like
Filed 1|Filed 2|Filed 3|Filed 4|Filed 5|Filed 6|Filed 7|Filed 8|Filed 9|
a|b|c|d|e|f |g|h|i|
1|2|3|4|5|6|7|8|9|
ab1|ab2|ab3|ab4|ab5|ab6|ab7|ab8|ab9|
TOTAL NUMBER OF CONSUMER RECORDS IS |0000000003|