Instead of posting my code I just made a different macro for the tx
files. So, now I have two. No big deal and I don't have to bother yo
guys so much. LOL Thanks for the help.

Ron de Bruin Wrote:
You close it after saving it to a xls
WBNew.Close False

Then you run this code

Columns("A:C").Delete
Columns("A:A").Insert
Columns("N:N").Copy _
Destination:=Range("A1")
Columns("N:N").ClearContents

Columns("C:AA").Delete
Columns("A:B").EntireColumn.AutoFit
Range("A1").Select

You run this on the activesheet on that moment

Then you want to save as a txt file and WBNew is closed so that is no
possible

Copy your whole macro in this thread then i change it for you



--
Regards Ron de Bruin
http://www.rondebruin.nl


[/color

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=39247