Working with other files

[steve]

is thier a way using vba to get a list of all files in a
given directory, and coping one or more of those files in
that directory to another directory with out opening the
files?

 

[Jim Rech]

You can use the Dir function to get a list of files and the FileCopy
function to copy them. VB help has more on these functions.

--
Jim Rech
Excel MVP
| is thier a way using vba to get a list of all files in a
| given directory, and coping one or more of those files in
| that directory to another directory with out opening the
| files?
|
|
|