Excel VBA Tips n Tricks #19 MkDir VBA Function Make folders and subfolders using excel

Подписаться 98 тыс.

Просмотров 72 тыс.

50% 1

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
Create folders and subfolders dynamically with Excel's VBA! This is super easy. Check it out!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Опубликовано:

25 апр 2013

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@Freenormable 6 лет назад

Really appreciate your video. I made some of my own mods using your examples. Great help. Thank you!

@ExcelVbaIsFun 10 лет назад

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

@711558 6 лет назад

thank you so much! it works perfect !

@krn14242 11 лет назад

Great tip, thanks Dan.

@davehollis7798 9 лет назад

Simply awesome video... finally found coding that really works. Excellent Job!!!!

@ExcelVbaIsFun 9 лет назад

Dave Hollis Thanks Dave, yes you can do anything you put your mind to with Excel. To learn more, check out my full 10 hour course, the Ultimate Excel Programmer Course - coupon is provided here for you. www.excelvbaisfun.com/ultimate-excel-course.html Cheers! Dan

@gillespiebrandon 10 лет назад

Great video. This functionality is super helpful for daily reports over multiple regions. I use a save feature in a "looping" report in conjunction with the today function to auto run and save reports to a specified directory. Kudos!

@ExcelVbaIsFun 10 лет назад

Cool Brandon! thanks for sharing!! dan

@linglinglow5961 7 лет назад

Thank you for this VBA it's amazing, but is there any to copy files into the folders which were created with MakeSelectioDir()?

@alperak8580 5 лет назад

thank you bro

@ExcelVbaIsFun 11 лет назад

justin, it's #26 of the Tips n tricks series. In the link above, replace the word " dot " with a period when copy/pasting. Can't get hyperlinks in here, so i used that.

@eugenioeudela6425 5 лет назад

can you make a macro that selects multiple files inside the folder

@karthi231093 3 месяца назад

Hello Sir My concept is to create a folder with Active cell name. If I click any cell in the excel then it has to create a folder with that name Is it possible to do ??

@justinmurray6327 11 лет назад

Hi David, I can not seem to get to the page? could you please give me the title to the video and I will look for it that way ? thanks

@limbov3122 2 года назад

How did you assign the 'x' to pick up selected folder? Doesn't work for me

@justinmurray6327 11 лет назад

Dan, so I had a skip through this video and don't exactly seem to understand all of this as my first ever vb use was yesterday. lol the this video was understandable and well done! from what I can get out of #26 it relates to my question but from my understanding of vb it is hard to decipher the code texts you are using haha. is there a way you can have a look at my problem? using a copy of the workbook I have created so far? based on what I have learnt from this video? Thanks for all your help

@allaiba.R 3 года назад

my vba its not working can help me please

@JohnSmith-mm6hf 9 лет назад

Nice video ("#19 MkDir VBA Function Make folders and subfolders"). Thanks for posting it. I am not seeing how we can apply that script/macro to a column of lets say 1000 unique names. I have column of 1000 names and I want each one of those names to become its' own folder in the test1 folder. How can we accomplish that using this macro?

@jimmietraylor7413 7 лет назад

Instead of using the Selection method, you would reference the Range. i.e For Each Cell in ws.Range("B1:B1000")

@napoleonmoscosa9353 Год назад

You can directly code, thats why your tutorial feels so complicated even its just simple topic

@ExcelVbaIsFun 11 лет назад

Justin, check out my video here where I address this incrementing Text + Number type serial codes. Just had this question come up this past weekend so I made a lengthy explanation. Feel free to skip around, but this should cover it, sir. youtube dot com/watch?v=6OFmI9rsFVw&list=PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_&index=30

@napoleonmoscosa9353 Год назад

You dont really need to tyoe all that nonsense in your excel file before coding new module

@napoleonmoscosa9353 Год назад

I dont like how you teach, please get to the point directly you been talking nonsense before you really do the tutorial 😅