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?

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

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

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