VBA: Create Multiple Folders from Excel Range

Рет қаралды 41,827

5 жыл бұрын

#CreateFolderCreate #VBA #ExcelAutomation
Hello Friends,
In this video you will learn how to create multiple folders using Excel range. This is very useful to in VBA automation.
Please download this excel file from below given link:
www.pk-anexcelexpert.com/crea...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert

Пікірлер: 75

@santiagogiraldo1860 4 жыл бұрын

Thank you very much I always struggle with this and finally I found a permanent solution! Great!

@PKAnExcelExpert 4 жыл бұрын

Glad it helped!

@AweshBhornya-ExcelforNewbies 5 жыл бұрын

Mr. PK this video is just too good. I have watched some of your videos in the past and have enjoyed them but this one is just tooooooooo good.

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@gentle2005phir 5 жыл бұрын

You deserve appreciation. I think now you shud come up with more and more VBA stuffs.

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@markdenney4938 4 жыл бұрын

Thank you for your excellent instructions!

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@skpaul6596 4 жыл бұрын

Mr PK ..wonderful application, it save time to create folder...I was struggling it long time..many thanks

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@mohankumar-lc3pm 5 жыл бұрын

Very useful video expecting more number of videos like this thank you very much

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@nairak 3 жыл бұрын

Useful to me ...tweaked a little bit to create standard set of subfolders within a root folder list too! Thanks!

@JenniSoprano 3 жыл бұрын

Oo how did you do that?

@nairak 3 жыл бұрын

@@JenniSoprano I wanted a standard set of folders....So I did as below: Sub Create_Multiple_Folders() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Sheet1") Dim sub_folder_path As String Dim i As Integer For i = 2 To sh.Range("A" & Application.Rows.Count).End(xlUp).Row sub_folder_path = "C:\Test" & "\" & sh.Range("A" & i).Value If Dir(sub_folder_path, vbDirectory) = "" Then MkDir (sub_folder_path) MkDir sub_folder_path & "\PTT_5G_2020" MkDir sub_folder_path & "\PTT_5G_2020\ABC" MkDir sub_folder_path & "\PTT_5G_2020\ABC\DRAWINGS" MkDir sub_folder_path & "\PTT_5G_2020\ABC\PERMITS" sh.Range("B" & i).Value = "Folder created!" Else sh.Range("B" & i).Value = "Folder Exists!!!" End If Next i MsgBox "Done!" End Sub

@balasubramanianshanmugam3721 5 жыл бұрын

Very useful.thanks for your service

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@laurentchristophemunier252 4 жыл бұрын

Thank you so much.

@drunkenstefania 4 жыл бұрын

Thank you very much for this useful video! I just wanted to ask you if there is a way to list the folders created with the macro in the exact order of the rows in the excel list. Thanks

@jasimalmeri1602 4 жыл бұрын

It work, amazing good job.

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@xxCarliuxx 3 жыл бұрын

Thanks so much for your help

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@JoshLearningLibrary 2 жыл бұрын

so great! very helpful

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback

@jojidodda9138 5 жыл бұрын

Mr. PK Good job.....This is excellent video. It is useful for me. Sir Mera Manna hai ki Agar Har folder me kitna Images (JPG, PNG etc) hai. For example:- Har ek folder me 40 se Adhik Images nahi hona chahiye. Iss topic pebhi video bananese bahuth achha hoga. Thank you.............

@MohAboAbdo 5 жыл бұрын

Thanks... Thanks.

@PKAnExcelExpert 5 жыл бұрын

Thanks for watching

@Norlen94 3 жыл бұрын

Hi Great video. I have a question. Is it possible instead of a predefined directory and range, the user gets to select where the folders would be created and the folders themselves would be based on the cells the user selected? more of a dynamic code.

@PSVRoger 2 жыл бұрын

What a information¡

@SathishJ 4 жыл бұрын

Awesome stuff, Can you help me making sub folders with this same technique with some modifications in the programme

@eleanortay2389 3 жыл бұрын

Thanks for the video! If I have individual files called EMP-1, EMP-2 etc, how do I move them to the new EMP-1, EMP-2 folders created?

@ProviderKnowledge Жыл бұрын

Thanks

@PKAnExcelExpert Жыл бұрын

Welcome

@KiyaniPlateOfFlavour 2 жыл бұрын

Looks nice let me try

@PKAnExcelExpert 2 жыл бұрын

Hope you enjoy

@rakeshbond009 5 жыл бұрын

Good one Bro. Keep it Up

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@bogdanbogdan2943 5 жыл бұрын

Mr. PK, good job.... Very nice what you do here, but will be more intresting that you will continue with "how to delete one folder". Thank you in advance :-)

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback. I will definitely try to make such video very soon

@mayanksakaria6238 5 жыл бұрын

Hi Hope you are doing well, Your videos are really awesome, I have learned many things from that. Justwanted to know do you have any video of automating letters using excel.. For example : if there is a letter template given on certain loaction and i need excel to open that and amend the required fills or empyt fills and create a letter in ms word.

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback. I will definitely try to make such video very soon.

@ezelkarlkl1284 3 жыл бұрын

Thank you for video. Can we do same things for create workbooks. I mean create new workbooks from cell range

@interested8430 2 жыл бұрын

Great video - how would you then once the folder is created make a hyperlink to go directly to that folder from excel through VBA? Many Thanks

@muhammednafiumminiyattil6889 4 жыл бұрын

This is very use full macro and thanks for the vedio.but i have one question. Is it possible to create excell sheet for each employees available in the work book in a perticular folder instead of creating folder? If yes, would you please do a vedio for the same.

@kiranarana7274 3 жыл бұрын

Thank you for your nice tutorial, the question is how can subfolders be created

@EpicShivExplorers 5 жыл бұрын

Very useful macro Sir I need one macro which copy the pertifcular file no. From one folder and paste that files into destination folder please help

@jasoncherene6801 3 жыл бұрын

Is there a way to get it to work with an ONEDRIVE pathway?

@inkarazhumakhanova2643 4 жыл бұрын

powerfull

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@inkarazhumakhanova2643 4 жыл бұрын

Hi Kumar, do you have any video's and examples of how to print using VBA list of PDF files? I have PDF files saved in a certain folder, there are thousands of PDF files them. Every time i process an order from customer I need to print some certain PDF files from that folder. it can a list of 10 or 20 or just one PDF file. What i would like to create in VBA is - i put a list of file names to be printed from that folder, press a button and they are printed. would be also cool to be able to print certain pages from these PDF files, so for example if i could put next to the list of file names the pages to be printed. and if also the macros can give me a message saying that this or that document could be printed, or some of the files were not found in the folder. i dont want to bother you, but i have tried so many videos and did not find so far what i need. i see that most people use shell function. I am medium level VBA user, i do programming good tools, but never met shell. thank you in advance

@vijaysahal4556 3 жыл бұрын

good sir 👍🏻👍🏻👍🏻👍🏻👍🏻

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@ujjawalso 3 жыл бұрын

1. can i create the folder with desired excel file in that folder in bulk folders ? 2. or can I rename of folder with my desired different names of folders ?

@technicalnekh8202 3 жыл бұрын

Thanks you very much sir for your kind sharing. It is very helpful to me. But I have a question if Column "A" is writing as a formulas, so how to fix or add in vba. Due to when I try to write as formulas it was error "Path not found". My highly appreciated for your kindness to solve this issue for me. Again, Thanks you very much sir.. From Cambodia Country:)

@michaela.brunson8529 3 жыл бұрын

Thank you for your tutorial. How can subfolders be created?

@PKAnExcelExpert 3 жыл бұрын

Good question! You can do it after little change in the code. I will try to create a separate video on this topic.

@ujjawalso 3 жыл бұрын

i want to put inside the desired files in each folders then how to do it ? please help

@user-yn3cj2ji9p 8 ай бұрын

Sir ji mero ko files bhi add karna hai har folder ke inside Mai. Aur condition bhi enter karna hai jisse duplicate files should not fetch inside the folder

@MeKavita 5 жыл бұрын

Hi, do you have any Vba code for below requirement please confirm e.g. Want to create Vba code to pull out d data from SAP application once open d respective tracker, paste d data and run d calculation in Excel tracker that already formulated. Once it's done go to Outlook and sent d mail to scheduled recipients

@PKAnExcelExpert 5 жыл бұрын

As of now I don't have such video ready. I will definitely try to make such video very soon.

@govindkumarsodani3290 Жыл бұрын

usefull😐

@PKAnExcelExpert Жыл бұрын

Thanks

@sushandutta3824 3 жыл бұрын

How to do the same in excel, which is located in Microsoft teams?

@munuaich9091 5 жыл бұрын

Inside the all folders I want to create subfolders for all , can you please tell me how to do this?

@nickblampied8784 4 жыл бұрын

Munu Aich I would also like to see how you make subfolders within the folders using this method.

@nickblampied8784 4 жыл бұрын

I would also like to see how you could make sub folders using the table method PK

@shawnkohl121 3 жыл бұрын

under the sub folder path it tells me it doesn't support this value.

@shawnkohl121 3 жыл бұрын

For i = 4 To sh.Range("A" & Application.Rows.Count).End(xlUp).Row sub_folder_path = sh.Range("C1").Value & Application.PathSeperator & sh.Range("A" & i).Value