Hello,

I have a macro which save xls to pipe delimited tx file without the double quotation marks but save the file as "text.txt". Need help for saving file name as original file name i.e. 0001.xls to be saved as 0001.txt & so on. The code i'm using is below:

Please Login or Register  to view this content.
Can someone please help me. Im using Excel 2003. Thanks