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

Video Description

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 ✅ VBA Course Download files: https://trumpexcel.com/course-download-files/ ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 ------------------------------------------------------------------------------------- 0:00 - Intro 0:14 - Setting up VBA for file operations 1:42 - Linking to Microsoft Scripting Runtime 4:26 - Creating a folder 8:18 - Copy files between folders 10:18 - Copying individual files 15:10 - Copying multiple files at once 22:58 - Working with subfolders ------------------------------------------------------------------------------------- #ExcelVBA #ExcelTips #ExcelTutorial