Copying Files From One Folder To Another

[richlocus]

Hello:
I know how to copy files from one folder to another folder using Windows Scripting Host. It is quite simple:
___________________________
strPathToCustomerInputTemplate = "C:\Users\" & UserNameWindows() & "\Documents\CustomerUpdates_Before"
strPathToCustomerOutputTemplate = "C:\Users\" & UserNameWindows() & "\Documents\CustomerUpdates_After"

Set FSO = CreateObject("scripting.filesystemobject")
FSO.CopyFolder Source:=strPathToCustomerInputTemplate, Destination:=strPathToCustomerOutputTemplate
__________________________
I could not find a function in Excel VBA that can copy all files in a folder to another folder without using the DIR command and looping. Is there a comparable native VBA command to do the same thing?

Thanks,
Rich Locus

[HansV]

No; the VBA command FileCopy does not support wildcards.