• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro to move xlsx xlsm in folders and subfolders to specific folder

R

RAM72

Member
I have a lot of folders with xlsx and xlsm inside on my desktop.

Is there a macro that can move all xlsx & xls file in their folders and sub folders to a specific folder on my desktop

C:\\User/User1/desktop/Atlas/xlsxtype

C:\\User/User1/desktop/Atlas/xlsxtype

However if there are duplicate found in another folder then do not move .

the files are scattered in different folders and subfolders on desktop c:\\User\User1\folder1\folder2 and so on .

but however do move anything in the folder Atlas
 
That's best done via TeraCopy or other tools meant for that sort of operation.

You could write a code, but it will have to traverse all the subfolders recursively and that's going to eat up resource and will likely result in overflow.

Try searching for "Free file management tools". You should find plenty.
 
You must log in or register to reply here.
Back
Top