★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Download the example file ★
exceloffthegrid.com/create-mu...
★ About this video ★
Over the past few months, I have seen many videos showing how to create folders multiple folders at once using a .bat file (also known as a batch script).
Often these videos leverage Excel to create the folder paths. Then, they undertake various manual actions to get the .bat file into the correct location, so they can execute the script.
It may be better than manually creating folders, but I believe there is a much easier way to create folders with Excel.
In this video, we work through a small project to create a tool that creates multiple folders at once.
0:00 Introduction
0:25 Create one folder with VBA
1:37 Handling errors
2:34 Folder from cell value
3:05 Folders from multiple cells
4:33 Add a button
6:04 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel
Негізгі бет Create multiple folders at once with Excel (the easy way!) | Excel Off The Grid
Пікірлер: 29