starsky
09-23-2009, 04:02 AM
Hi,
I've a macro that will look through all subfolders in a parent folder, and copy all xls files to another destination. However, I want to exclude one subfolder from that search (an archive that doesn't need to be copied). How can I adapt the following piece of code to do this?
With Application.FileSearch
.NewSearch
'Change path to suit
.LookIn = C:\ParentFolder\"
.SearchSubFolders = True
.FileType = msoFileTypeExcelWorkbooks
Many thanks.
I've a macro that will look through all subfolders in a parent folder, and copy all xls files to another destination. However, I want to exclude one subfolder from that search (an archive that doesn't need to be copied). How can I adapt the following piece of code to do this?
With Application.FileSearch
.NewSearch
'Change path to suit
.LookIn = C:\ParentFolder\"
.SearchSubFolders = True
.FileType = msoFileTypeExcelWorkbooks
Many thanks.