Thank you verymuch . this is really nice and useful. I have a little further query. If 5 folders are having multiple sub folders. how should i take all sub folders in a side by side row? please help me to get the code.
Sir, Thank you very much . Can you also explain how do you populate the Serial Numbers in your Final execution of the macro automatically in Column D? It is not visible as a Macro Code.
I appreciate that you noticed it. The serial numbers in the Column D are created using 2 formulas. Formula in the cell D2 is =IF(E2"",1,"") if the cell E2 is not blank, return 1, otherwise return nothing. Formula in the cell D3 is =IF(E3"",D2+1,"") means if the cell E3 is not blank, return value in the cell D2+1, otherwise return nothing.
Really nice video.. I have use this code in my excel but and only getting name for folders but not getting name for all the sub folders or folder which is created under subfolder.. So for this any changes required in code please let me know
I want to create a list of the parent folder of my selection, including the subfolders and and deeper nested folders and all files across all levels of directories. I also want them to be organized by Date created, date modified, size, type, name and path. How can I do this with excel vba? I have windows 10 with microsoft 365. Thanks
Hi Ajay, When i try to run ListFileNames Macro it did not work. I tried exactly instructed in your video. I made sure Macro is enabled but still when pressed the Get File Names command button nothing happened.
bro can u provide me a vba code that can open all the folder and extract all the specific file names for eg: only pdf.also can u provide me a code that can copy a folder path into destiontion path?
One more easier way to copy folders or files name in excel.... Just select all then press and hold Shift key + right click then look for copy as path and simply paste in excel. Too simple.
Thank you verymuch . this is really nice and useful. I have a little further query. If 5 folders are having multiple sub folders. how should i take all sub folders in a side by side row? please help me to get the code.
Thank you very much for this video. How can we do same things for FOLDER and SUBFOLDER names with file names ?
Sub ListFileNames()
Dim X As Object, XNC As Object
Dim Y As Integer
Set X = CreateObject("Scripting.filesystemobject")
Set XNC = X.GetFolder(Range("B2").Value)
For Each Z In XNC.Files
Y = Y + 1
Worksheets("File Names").Cells(Y + 1, 5).Value = Z.Name
Worksheets("File Names").Cells(Y + 1, 6).Value = Z.Path
Next
End Sub
Sir, Thank you very much . Can you also explain how do you populate the Serial Numbers in your Final execution of the macro automatically in Column D? It is not visible as a Macro Code.
I appreciate that you noticed it. The serial numbers in the Column D are created using 2 formulas.
Formula in the cell D2 is =IF(E2"",1,"")
if the cell E2 is not blank, return 1, otherwise return nothing.
Formula in the cell D3 is =IF(E3"",D2+1,"")
means if the cell E3 is not blank, return value in the cell D2+1, otherwise return nothing.
@@AjayAnandXLnCAD на русском:
D2 =ЕСЛИ(E2="";"";1)
D3 =ЕСЛИ(E3="";"";D2+1)
Wonderful coding...Thank you Ajay.
Really nice video.. I have use this code in my excel but and only getting name for folders but not getting name for all the sub folders or folder which is created under subfolder.. So for this any changes required in code please let me know
Thank you so much. It was very helpful!
Glad it was helpful!
Thank you so much ! Its so informative
You're so welcome!
I want to create a list of the parent folder of my selection, including the subfolders and and deeper nested folders and all files across all levels of directories. I also want them to be organized by Date created, date modified, size, type, name and path. How can I do this with excel vba? I have windows 10 with microsoft 365. Thanks
That's exactly what I am looking for.
me to :-)
Very great. Thank you
Thank you so much... i was trying do this today and my code didn't working anyway... I'm from Brazil and you channel is help me so much....
Glad to hear that. I recommend to visit my website for more VBA codes and a free ebook.
Thank you this is very useful section. Can you do one section on how to list out all external links i.e folder , file name in one workbook please?
Thank you, Ajay, for those sandwiches !!
By the way, excellent work ! 💖💖💖
You are welcome, Miss. MonteNegro :)
Hi Ajay, When i try to run ListFileNames Macro it did not work. I tried exactly instructed in your video. I made sure Macro is enabled but still when pressed the Get File Names command button nothing happened.
Thnx. Very good.
Nice video ... How to bank reconciliation with cashbook in Excel
Thank you for the feedback.
I haven't tried cashbook reconciliation in Excel.
What if I have 100 songs inside a folder and I want to extract the name and also the *_DURATION_* of each song in the excel file?
I also want the file date. How can we add that? Any help please? Thank you
You are super bro ❤️
Hi Sir Thank u so much for this Video... learnt a lot...plse give what formula used to get automatic SL# in the file..
Thanks in Advance
What do mean by automatic SL#
How can you get the Parent Folder Name, Sub-Folder Name and File Named (hyperlinked) in 3 columns in excel worksheet?
I suggest to use SPLITTER function (which I have explained in another video) or the Text to Columns feature for separating Folder and File names.
bro can u provide me a vba code that can open all the folder and extract all the specific file names for eg: only pdf.also can u provide me a code that can copy a folder path into destiontion path?
Thank You Ajay For Considering My Request.
My pleasure 🖐️
Same Option How to Set LibreOffice Calc
It shows Run time error 438
It is not working
How can we add Authors name of File ?
Hi need your help in creating macro to send chaser mail Or create folder for 3000 line items.
Can you be more specific?
One more easier way to copy folders or files name in excel.... Just select all then press and hold Shift key + right click then look for copy as path and simply paste in excel. Too simple.
coudl it be possible to move multiple PDF files to respective subfolders which created in another path based on PDF name or number