convertion xlsm to pipe delimited file

I am using this code to convert a xlsm into a pipe delimited file. That part works for me. But here comes the fun part. Its not exactly in the correct format.

Please Login or Register  to view this content.

The formatting of the output is what I did not know until I posted the macro.

So here is the message I got after posting the macro on the boards.

"The problem may be that the pipedelimited file isn't in the format that suitcase needs it to be.
It needs to be in the form of (using dark ritual as an example):

Please Login or Register  to view this content.

I don't know how to write the marcros but take note of the edition and how suitcase recognizes it. The assumption is there needs to be some code that converts it to this exact format and to have place holders where the columns are not used... E.G StdDev, Average, High, Low, Change, Raw N are all not used (I'm assuming here).
So taking the Tempest Dark ritual as an example, it should take the line from Tcgplayer.xls:

Please Login or Register  to view this content.

and after running macros, spit out:

Please Login or Register  to view this content.

StdDev, Change, and Raw N set to default values of 0.00, 0.00, and 1 respectively."

This is the excel file http://www.mediafire.com/?zmwlnvac4ne4r01

And this is the output I get when I use the above post.
http://www.mediafire.com/?8ax56fru5fa450f

Any help with this would be amazingly helpful.
Thanks.