Learn Excel - Video 599 - VBA- Move files from subfolder to folder

How to move files lying in multiple sub folders to main folder using vba.
if you like to give donation , if videos are helping please visit
if you like to purchase or join my weekend online training pls visit my website and click on purchase icon

[ashubedi]

I really found your every video quite informative and sharing such knowledge at no cost in itself a very big thing. I really appreciate your all hardwork and efforts.

[ashubedi]

Could you please assist on how do we move multiple files to a diff folder provided each day we receive new files however the names of such files are same everyday but with diff dates and according we need to drop all files to their respective folder as per the name it contains.

[benb]

Thank you very much this answers my question on video 551 that I had as well!

[munuaich]

Hey, if I am transferring bulk files for the extension.bnc, it’s not working for me.

[gunasekaran]

Sir where to copy this code and work in my system. I need to type all the syntaxes manually. If error. Each and every time pause and checking.. literally making irritate sir...

[sunilvashist]

This is really a cool video. Thanks a lot

But I got stuck here when I am trying to copy a file from a folder and want to paste the same in all the subfolders of a main folder.

Plz help me with this asap.

[Evolutiontestweekies]

Hi thank you very much . I have a question
1. If File in Source Folder have update, Can I check and copy only update file to destination folder ?
2. If In Source Folder have many sub folder ex. Main fol -> Sub fol 1 -> Sub fol 2. How to Loop check and and copy to destination folder ?
Please explain to me ^^

[nbiligiri]

Hi Ajay Kumar, Thank you very much for your video, it amazing, actually I am looking for something same this video, my requirement is; ex I have around 1000+ serial numbers (each serial numbers having unique 18 digits), with the same serial number containing 4 to 5 excel files are created in folder and many subfolder with some extend (like with date or time so and so),
so VB need to be read the required serial numbers from 1 excel file and search that related all files in all folder and need to copy those sheets into desired new folder

thanks,
Nagaraju B

[souryarakshit]

Can you. Please help ...i am having error...as soon as there is duplicate file ..i want the macro to ignore a duplicate file

[dineshpanihar]

I am getting an error that is run time error 70 (permission denied) when copying files from subfolder to mainfolder or another folder, please tell me how to handle this error or give the permission to copying files .

[krmotionexcel]

Sir Ji
Can you make currency exchange rate to web notification in direct by excel
Like Rupees, USD.... Or other
With word .
Can you make this
I have big

[vikas]

Is it possible that as soon as I update the following details in some headers in Excel, the data in multiple Microsoft Word files (attached to the Excel file) get updated automatically and also save all the updated Microsoft Word files in one folder? Does it, from the given unique number in Excel?


Excel Header Detail

A B C D
1 Name Unique Number Mobile Number Value
2
3
4
5
6