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

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ 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/trumpexc...

-------------------------------------------------------------------------------------
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