Create the list of Files and Sub-folders in a Folder in Excel (Macro to list File Names)

Following 3 Excel Macros are explained in this video.
1. for listing the Files in a folder
2. for listing File Paths of files in a folder
3. for listing Subfolders in a folder

Subscribe to the channel for more

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

#MacroToExtractFileNames #MacroToListFiles #MacroToListFolder
#MacroToCreateListOfFiles

[adrianjeffery]

Thank you so much ! Its so informative

[annafranz]

Thank you so much. It was very helpful!

[ezelkarlkl]

Thank you very much for this video. How can we do same things for FOLDER and SUBFOLDER names with file names ?

[haddadikram]

Sub ListFileNames()

Dim X As Object, XNC As Object
Dim Y As Integer

Set X =
Set XNC =

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

[krishnamaruthipeddinti]

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.

[morrisonka]

Thank you, Ajay, for those sandwiches !!
By the way, excellent work ! 💖💖💖

[danielle]

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?

[rajagopalanpk]

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.

[isaiass.]

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....

[sat]

Nice video ... How to bank reconciliation with cashbook in Excel

[rahulkamble]

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

[pakkruikkru]

Thank You Ajay For Considering My Request.

[anmac]

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

[zuhebkhan]

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

[mailsuren]

coudl it be possible to move multiple PDF files to respective subfolders which created in another path based on PDF name or number

[amitoswal]

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.

[daleramsawak]

How can you get the Parent Folder Name, Sub-Folder Name and File Named (hyperlinked) in 3 columns in excel worksheet?

[popeyefoodpoint]

Same Option How to Set LibreOffice Calc

[adrianjeffery]

I also want the file date. How can we add that? Any help please? Thank you

[umeshadvani]

Hi need your help in creating macro to send chaser mail Or create folder for 3000 line items.