Copying all files from one directory to another 1

[rockfish12]

How could I copy all files from one directory to another...for instance, from my CD drive (d to my hard drive (c? (I've read that there may be some FileCopy function, which I tried, but Access 2000 didn't seem to recognize it. I even looked for it in VBA help, but it was nowhere to be found)

 

[kevinclark]

Sub CopyFiles()

'if you set a reference to the Microsoft Scripting Runtime
'Library from Tools ... Reference menu then you can simply
'use Dim FSO as FileSystemObject
'Else you can use the following two lines
Dim FSO
Set FSO = CreateObject("Scripting.FileSystemObject&quot
'Create this would copy contenst of Test1 into Test2
FSO.CopyFolder "c:\mydocuments\Test1\*", "c:\mydocuments\Test2\"

End Sub