View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default copy from multicolumn .txt document

Well, record the macro of the Open file option and see the code.

As for the rename, use
Name "mz.txt" As "mz.csv"
adding paths as required.

NickHK

"rea" wrote in message
oups.com...
it is one solution, but i need to have a code, becuse mz txt is
generated from another program wich recives data from rs232... so it is
a bit complicated,but the point is that i need to code.