Hi,

I've learned through this site how to copy a file from one folder to another with this code:

Dim SourceFile, DestinationFile
SourceFile = "SRCFILE"    ' Define source file name.
DestinationFile = "DESTFILE"    ' Define target file name.
FileCopy SourceFile, DestinationFile    ' Copy source to target.
this requires that you know the specific filename. Unfortunately, I won't know the filenames that I'll be copying. I just need to copy everything in the folder. Is there a way to do this, with or without the code above?