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.............
@@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
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 :-)
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
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 ?
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.
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.
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.
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:)
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
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
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
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
You deserve appreciation. I think now you shud come up with more and more VBA stuffs.
Thanks for your valuable feedback
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.
Thanks for your valuable feedback
Very useful video expecting more number of videos like this thank you very much
Thanks for your valuable feedback
Thank you very much I always struggle with this and finally I found a permanent solution! Great!
Glad it helped!
Mr PK ..wonderful application, it save time to create folder...I was struggling it long time..many thanks
Thanks for your valuable feedback
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.............
Useful to me ...tweaked a little bit to create standard set of subfolders within a root folder list too!
Thanks!
Oo how did you do that?
@@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
Very useful.thanks for your service
Thanks for your valuable feedback
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 :-)
Thanks for your valuable feedback. I will definitely try to make such video very soon
Thank you for your excellent instructions!
Thanks for your valuable feedback
Thanks
Most welcome
good sir 👍🏻👍🏻👍🏻👍🏻👍🏻
Thanks for your valuable feedback
so great! very helpful
Thanks for your valuable feedback
Thank you for video. Can we do same things for create workbooks. I mean create new workbooks from cell range
Thanks so much for your help
Thanks for your valuable feedback
Looks nice let me try
Hope you enjoy
What a information¡
Good one Bro. Keep it Up
Thanks for your valuable feedback
It work, amazing good job.
Thanks for your valuable feedback
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
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?
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
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 ?
Thank you for your nice tutorial, the question is how can subfolders be created
Thank you for your tutorial. How can subfolders be created?
Good question! You can do it after little change in the code. I will try to create a separate video on this topic.
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.
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.
Thanks for your valuable feedback. I will definitely try to make such video very soon.
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.
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:)
Thank you so much.
Thanks... Thanks.
Thanks for watching
Awesome stuff, Can you help me making sub folders with this same technique with some modifications in the programme
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
usefull😐
Thanks
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
As of now I don't have such video ready. I will definitely try to make such video very soon.
powerfull
Thanks for your valuable feedback
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
Inside the all folders I want to create subfolders for all , can you please tell me how to do this?
Munu Aich I would also like to see how you make subfolders within the folders using this method.
I would also like to see how you could make sub folders using the table method PK
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
Is there a way to get it to work with an ONEDRIVE pathway?
i want to put inside the desired files in each folders then how to do it ? please help
How to do the same in excel, which is located in Microsoft teams?
under the sub folder path it tells me it doesn't support this value.
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
getting error that " object does not support this property or method"
but it is not creating the hindi name folder
One folder create করতে চাই worksheet one cell value থেকে . কিভাবে করব
Thanks
Welcome