Free Excel VBA Course #34 - Working with Files and Folders using Excel VBA (Copy files and Folder)

In this video, I will show you how to work with files and folders in Excel.
The video will cover:
-- How to create a new folder using Excel VBA
-- How to check if the folder exists of not using VBA
-- Copy a file from one folder to the other
-- Check if the file exists or not
-- Copy all file (or files with specific extensions)
-- Copy files as well as a folder
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial

[@mtotowamungu8259]

This is the best explanation I've seen so far. Many thanks.

[@trumpexcel]

Glad you found the video useful!

[@vincysigma]

You are a wonderful Teacher Sir.. Well explained.. Thanks

[@ricardoantunes9134]

Many thanks!! I've looking for such explanation for a long time!! Great explanation!!

[@Tushar22011998]

Thank you so much. This helped me to get the name of all the files present in a folder.

[@jackng7234]

Great video with details step. Thanks !!

[@vijaysahal4556]

very useful sir 👍👍👍and yours teaching way also fine 👍👍👍👍

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@triggergamer1066]

best ever explanation wow

[@pappasmurf9930]

Love this video - very helpful! What's the difference between this way and using mkdir? pretty sure this syntax also makes folders and directories?

[@vinayababuyerneni255]

All I can is Thank you !!!!

[@abhishekchaturvedi6981]

Please make a video on Microsoft Powerpoint as well as TrumpPowerPoint it will be very useful for the beginners 🙏🙏

[@jojocarrillo]

Thank you. but i would like to copy multiple files within different folders into one folder based on a database which contains the reference e.g. WF-002811 R2 (database ref) > WF-002811 R2 EMBEDDED LAYOUT OF C1 4TH FLOOR (actual folder name)... I was thinking of using the search function in VBA to solve this and I need it to loop through the whole database and copying all the files. I'm new in VBA.

[@pradnyahasabnis1107]

Thank you very much.

[@trumpexcel]

Glad you found the video useful!