excel to text, default tab delimited text file

[nischalinn]

When I converted excel to text file via VB code, the default text file is tab delimited. Why is it so?


I've done:

Sub ConvertToText()
    ActiveWorkbook.SaveAs Filename:="E:\EXCEL\TEST.txt", FileFormat:=xlCurrentPlatformText, CreateBackup:=False
End Sub

Can I change the default delimition to pipe, how can I do this? How can I make an excel file to pipe delimited text file in default?
Please can anyone explain that to me.

Thanks a lot!!!

 

[Br0ck]

I believe this link will answer your first question...

McGimpsey & Associates : Excel : Text Files

And this for your second...

Windows XP Hack: How To Use a Pipe ("|") Delimiter in Microsoft Excel With CSV Files

 

[nischalinn]

Hi Br0ck,

Thank you very much for your reply.

I'll try the solution and post the result.

Thanks a lot!!!

 

[nischalinn]

Hi Br0ck,

I read the link and found that this tutorial was for converting PIPE delimited CSV file to EXCEL file.
But my problem is to convert EXCEL file to PIPE delimited text file. Though I followed the steps given in the tutorial, but it did not work.

Please suggest how to solve this problem.

Please do response on this post.

Thank You!!!