change the file format of a text file.

[GeneWan]

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?

[Leith Ross]

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

[GeneWan]

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
>
>

[NickHK]

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

NickHK

"GeneWan" <[email protected]> wrote in message
news:[email protected]...
> 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
> >
> >