change the file format of a text file.
 

I need to abstract data from a text file, but if the file extension is
".log", I need to change it to ".txt".

I can only think of doing this by first opening "ABC.log" (in the
background), upon detection of a .log extension, will use "Save As.. ABC.txt

this was what I did manually at first, but I need to speed up as there are
going to be tens of files with .log extension to be converted..

can anyone help?

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

change the file format of a text file.
 

Hi Leith,

Would this create a new copy or does it overwrite the original file? My
intention is to save it as a new file with the similar filename.


"Leith Ross" wrote:


Hello GeneWan,

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

Name filename.log As filename.txt

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=545734

change the file format of a text file.
 

Gene,
FileCopy "c:\Source.txt", "c:\Source2.txt"

NickHK

"GeneWan" wrote in message
...
Hi Leith,

Would this create a new copy or does it overwrite the original file? My
intention is to save it as a new file with the similar filename.


"Leith Ross" wrote:


Hello GeneWan,

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

Name filename.log As filename.txt

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=545734