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