VBA to Export to Notepad from Excel.

Hi,

In sheet1, I have a values in Coloum A, B , C and D.

A : John,
B : 1283
C : 01/10/2013
D : USD

Is it possible to convert/export value to "note pad" by using ""|"" as separator with the help of VBA?

John | 1283 | 01/10/2013| USD

Thanks,
SHiva