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