View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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?
|
|
|