VBA to search recursively

My macro below checks if the files listed in column A exist in the source folder. If they do then it moves them to the destination folder. Source and destination folder paths are input via message box prompts.

Please Login or Register  to view this content.

It works fine , but only searches the top level of the Source folder , and not within its sub-directories.

Can someone suggest a modification to the code so it searches the source folder recursively , perhaps with an extra Yes / No prompt?

Grateful for any advice.

Thanks Marc L. I can see this advises the topic , but not sure where it resolves the question of practical implementation into the code above.

Thanks again Marc L. I was hoping to adapt the existing code rather than re-write , if possible.

Hi mjr veverka - Sorry that's a typo. It should read :

"My macro below checks if the files listed in column A exist in the source folder. If they *do* then it moves them to the destination folder."

I'll amend accordingly.

Originally Posted by CDandVinyl

it searches the source folder recursively

"Recursion" is not needed here, an appropriate approach to the results of certain system commands (e.g. attrib, dir, robocopy, xcopy) from the DOS era is enough.

Ok thanks guys. I'm afraid I'm not at all familiar with the methods you suggest but I'm grateful for your input.

mjr veverka I'm sorry if my original request remains unclear. I'm grateful for your example script.