I'm tring to add a bit of code to my VBA in excel that will:

Save a text file in a directory as a new file in another directory.

Many Thanks

--
Message posted from http://www.ExcelForum.com

"Sladey " schrieb im Newsbeitrag
...
I'm tring to add a bit of code to my VBA in excel that will:

Save a text file in a directory as a new file in another directory.

Many Thanks.


---
Message posted from http://www.ExcelForum.com/


Hi Sladey,

in other words: you want to copy a file from one directory to another? If
so:

FileCopy source, destination

is your friend. You can provide a fully classified file name for the
arguments.

FileCopy "c:\temp\myfile.txt", "c:\newdir\myfile.txt"

cheers,

Stephan