Folder Copy

The VBA alternative would need to verify that the folder existed and then loop through all the files in that folder, copying each, one at a time.

Function CopyFolder(source As String, _ 
                    destination As String)
Dim fso As New Scripting.FileSystemObject
   On Error GoTo errHandler
   fso.CopyFolder source, destination
   Set fso = Nothing
Exit Function

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext