View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_561_] Leith Ross[_561_] is offline
external usenet poster
 
Posts: 1
Default change the file format of a text file.


Hello GeneWan,

You can do this more easily by using the Name statement. Once your fil
is closed use the following in your VBA code...

Name filename.log As filename.txt

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=54573