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

Рет қаралды 19,532

Күн бұрын

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: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 16

@mtotowamungu8259 4 жыл бұрын

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

@trumpexcel 4 жыл бұрын

Glad you found the video useful!

@vincysigma 3 жыл бұрын

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

@Tushar22011998 4 жыл бұрын

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

@ricardoantunes9134 3 жыл бұрын

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

@vijaysahal4556 4 жыл бұрын

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

@jackng7234 4 жыл бұрын

Great video with details step. Thanks !!

@pappasmurf9930 3 жыл бұрын

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

@abhishekchaturvedi6981 4 жыл бұрын

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

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@triggergamer1066 2 жыл бұрын

best ever explanation wow

@vinayababuyerneni255 2 жыл бұрын

All I can is Thank you !!!!

@jojocarrillo 4 жыл бұрын

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.