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