This code will allow you to use the wildcard character to copy files.
Option Explicit
Private m_Cancel As Boolean
Private Sub Command1_Click()
Dim lFilesCopied As Long
lFilesCopied = ZCopy("c:\temp", "d:\mytemp", _
"*.*", m_Cancel)
End Sub
Private Sub Command2_Click()
m_Cancel = True
End Sub
Private Function ZCopy(FromDir$, ToDir$, Filter$, _
Optional Cancel As Boolean = False) As Long
Dim szResult As String
Dim lCounter As Long
On Error GoTo OOPS
FromDir = FromDir & IIf(Right$(FromDir, 1) = "\", "", "\")
ToDir = ToDir & IIf(Right$(ToDir, 1) = "\", "", "\")
szResult = Dir$(FromDir & Filter)
Do While Len(szResult) > 0
If m_Cancel Then
m_Cancel = False
Exit Do
End If
DoEvents
Call FileCopy(FromDir & szResult, ToDir & szResult)
szResult = Dir$
lCounter = lCounter + 1
Loop
ZCopy = lCounter
Exit Function
OOPS:
ZCopy = -9999
End Function