Can you manipulate text documents using VBA in excel

S

Sladey

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
 
S

Stephan Kassanke

Sladey > said:
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.
Click to expand...

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
 
Top