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

preview_player
Показать описание
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

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

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

mtotowamungu
Автор

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

vincysigma
Автор

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

ricardoantunes
Автор

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

Tushar
Автор

Great video with details step. Thanks !!

jackng
Автор

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

vijaysahal
Автор

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

pappasmurf
Автор

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

abhishekchaturvedi
Автор

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.

jojocarrillo