Working with other files
 

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?

Working with other files
 

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
"steve" wrote in message
...
| 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?
|
|
|