Option Explicit Sub CopyFilesFromSubFolders() Dim FSO As Object Dim FromPath As String Dim ToPath As String Dim FileExt As String Dim SubFolder As Object Dim CurrentFile As Object FromPath = "F:\test\top\" '<= Change to suit ToPath = "F:\test\everything\" '<= Change to suit Set FSO = CreateObject("Scripting.FileSystemObject") For Each SubFolder In FSO.GetFolder(FromPath).SubFolders For Each CurrentFile In SubFolder.Files CurrentFile.Copy (FSO.BuildPath(ToPath, CurrentFile.Name)) Next Next SubFolder Set FSO = Nothing Set SubFolder = Nothing Set CurrentFile = Nothing MsgBox "Done" End Sub
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter