👍Several hours watching videos and I finally found a simple one that works.

Thanks for this. I've been trying to do things like this for a long time. I like your solution. It is straightforward and clear. I also learn a lot from your teaching technique where you show everything from setting up the references to seemingly writing the code on the fly and solving issues as they come up, just as in real life.

Very helpful indeed. Works perfectly. Many thanks!

Wow! This works! THANK YOU! Your explanation to each line was superb. Liked and Subscribed!

This is amazing! Have been looking for this for a long time. Thanks a lot :)

This is what I want .... thank you very much sir......hats off to u

Awesome video! Very helpful.

Very helpful, thank you for sharing.

Thx for sharing as I was just looking into to do the same in VBA.

Very helpful video !!!

Super helpful... thanks!!!

Thanks a lot this is very good session

Thank you so much. Works great with my file.

Very Good!

Thanks for sharing such a wonderful macro. It helps me a lot.

Wow!! You are awesome!!

Thank you so much.

This works very well, however I am having difficulty extracting certain metadata/file properties. "Subject, comments, title, and content status" I am unsure what makes these different from the properties that can be extracted.

Thank you

Thanks a lot, I was looking for this solution for a quite long time. Just one question, how do you do the second line of your Excel, where you are able to insert the desired path?

Thank you bro...

Super nicely explained

Great video, thanks. One ? How do I change the starting row for the report to start populating? If I want this to start in cell A5.

Thank you so match, Sir.

amazing

Hi Kamal, thanks for the walk through. Can you also advise what code would be used if I also wanted to check whether these files are password protected or not?

Thanks for this is it possible to adapt this code to pull a list of subfolders only starting with 2020 for example?

Very well explained this video.. Will you please make a video of how to search files from the excel sheet(file names will be typed in A1 by user) in sub-folders and paste them in to a destination folder..

Thanks a ton..

THANK YOU VERY MUCH.... :)

Hi Kamal, Thanks a lot for a very good 'take through' scripting video. Could we add folder and subfolder names to be included amidst in the rows in the 6 column fields? Could you please explain how to include folder and subfolder names listed between these file names. Regards Sharma

Very good explanation, How can I get the image Dimensions (Length and Width)? Thanks

Hi thank you. It helped me for my small project. Is it possible to add 2 columns, one with the files md4 hash and one the files md5 hash?

Hi! First of all, thank you for your work, really appreciate. I know nothing about VBA. I try to edit the code to add two more columns: Framerate and Video length, but it`s not working. How can I retrieve those file attributes?

Great...thanks..here u have a new subscriber👏🏻

just a newbie here: Q: At 7:25, you cut "Dim objFile As Scripting.File" and put it one line below, does it matter something? In this actual case, does it really matter you put in one line below after the folder line?

Hello! I love this video, and we actually have used this macro extensively. However, I had a question--how can I find out who the file OWNER is (aka the person who last used/saved the document)?

Hey, thank your explanation, i need your help for find date of workbook's name and copy it to a column, example: "workbookname 01 2020" copy to column "date", 01/2020 on this format . thanks in advance.

thank you so much for this great tutorial! it works for me only the get details without subfolder but when I tried to include the code for subfolder it didn't work. why? here's the code. Option Explicit Sub listAllFiles() Dim objFileSystemObject As Scripting.FileSystemObject Dim objFolder As Scripting.Folder Set objFileSystemObject = CreateObject("Scripting.FileSystemObject") Set objFolder = objFileSystemObject.GetFolder("C:\Users\hp\Documents\XXX") Call GetFileDetails(objFolder) End Sub Function GetFileDetails(objFolder As Scripting.FileSystemObject) Dim objFile As Scripting.File Dim nextRow As Long Dim objSubFolder As Scripting.Folder 'Set objFileSystemObject = CreateObject("Scripting.FileSystemObject") 'Set objFolder = objFileSystemObject.GetFolder("C:\Users\hp\Documents\XXX") nextRow = Cells(Rows.Count, 1).End(xlUp).Row + 1 For Each objFile In objFolder.Files Cells(nextRow, 1) = objFile.Name Cells(nextRow, 2) = objFile.Path Cells(nextRow, 3) = objFile.Size Cells(nextRow, 4) = objFile.Type Cells(nextRow, 5) = objFile.DateCreated Cells(nextRow, 6) = objFile.DateLastModified nextRow = nextRow + 1 For Each objSubFolder In objFolder.SubFolders Call GetFileDetails(objFolder) Next Next End Function

Thats Wonderful tutorial Sir.. Thank you

I am new to VBA and this works great! Thank you! How do I get the button in my Excel sheet to insert the path as shown in your example?

Hi Kamal, Thanks for this video. But kindly walk us through how we can give file directory where we need to check ?

Hi XtremeExcel, Is there a code to pulling the Username of who created the files or folders? Thanks for creating this video, it's a big help. Ken

Hi! Thanks for the video! Is there's any way to get the author and last person thay modify each file?

Thank you so much I tried many codes but I couldn't able to enter the subfolders thanks a lot😃

I got permission denied if i want to read the root drive letter, e.g. d:\ etc. How do resolve it ? thx

How is it if you just intend to get files beginning to a certain value, say example, "macro". It will just get all filenames beginning with "macro"

Thank you for such a good walkthrough. I have tried following, but it seems that the value for date and time that I get is in serial number. Is there any way that I could get the normal date and time format straight away?

Thanks what will be the code for above foder path cell with button option

Thanks a lot, I love the Idea and tried myself step by step, but somehow my script is not working (sad).This line with ">" shows me all the time "Run-time error '13' Type mismatch" maybe you know why. Will apriciate any help: nextrow = Cells(Rows.Count, 1).End(xlUp).Row + 1 > For Each objFile In objFolder.Files Cells(nextrow, 1) = objFile.Name Cells(nextrow, 2) = objFile.Path Cells(nextrow, 3) = objFile.Size Cells(nextrow, 4) = objFile.Type Cells(nextrow, 5) = objFile.DateCreated Cells(nextrow, 6) = objFile.DateLastModified

Very helpful vedio for us Sir can you send code. It's very helpful for me Thanks

how do you do the second line of your Excel, where you are able to insert the desired path? Please Help

Thank you very much for this interssing and useful video.. is it possible to do same thing with a folder in a cloud? for example in google Drive.

Nice video, do you know how to pull folder, Filename info from sharepoint library? and how to upload to sharepoint library from local drive. Thank you

Would you be able to share the complete code or the template file for ready to use kind

is it possible to get a list of all directories and all its subdirectories as well ?? for example, i want ALL FILES and ALL DIRECTORIES INCLUDING SUBDIRECTORIES AND ALSO PARENT DIRECTORY of C:\Users\[computer user]\Downloads\ ??

Hi there, Can someone help with that: "variable not defined" ...it refers to the Sub FetchFileNames(objFolder As Scripting.Folder, IncludeSubFolders As Boolean) I basically copied the code shown @1:36

Great tutorial. However I am encountering one problem. I work in an organization where the number of files are huge and when I run the macro it gets to around 55000 rows after which I get an error. I think there is a stack overflow after certain number of files.

Can we get audio file duration using this

Nice video sir ...but i have one query ...how to connect path to text box ..for fetch data ??Please guide me how to create same sheet you have ...

While doing same with taking path from shared folder from network...it too slow...how to resolve this..please help

How Can i add browse Code instead of Paste destination Path In VBA code & Object for Browse code in this Same Code.

Hi, can please shown the full codes in module 1.

Can you help me with recognize text ocr on multiple Ms word files? I need to be able to retitle and date multiple documents (documents are all Ms word and the page is setup the same), please? The date and title have to be from the document itself not the file details in Windows Explorer.

Hi, thanks for the video.. I have tried But it took more than 2 min to run the macro for 2400 files+. How can I improved it?

Good explanation..can we get the no of rows used count.

@ 5:30 why do you use createobject that too after you have already referenced MS Scripting Runtime library. You could have just set objFSO = New Scripting.FileSystemObject.

I am get an error on End(x1up) on below line which show compiler error nextRow = Cells(Rows.Count, 1).End(x1up).Row + 1 and one line is yellow,that is "Function GetFileDetails(objFolder As Scripting.Folder)" what is the solution ???

i pretty much copy the code (except the folder path) on the video but somehow getting Compile error: Variable not defined. on the line 'Function GetFileDetails(objfolder As Scripting.Folder) why is that?

Is that possible to share this file to my mail

Great video! Would this work on a shared drive?

Share a file which can be embedded in Excel to run described function

Great video, i have a question, is it possible to remove the file type extension?

Sir, Pls upload new video on cell protected after input value in cell. Sheet should be shared in office common drive not by Gmail etc. Multiple users would be working on the same sheet.

Hi can I perform the same function for multiple paths??

Hi How we defined the path by user

Thank you so much. Need a small help. I need the file names in MS Teams SharePoint. When I give the SharePoint path, VBA says path not found. Can please help me on it. Thanks in advance

I need only xlsx file name, is that possible

Hello Thanks for such a informative video. When I tried using this code it is giving me "Runtime error 91 Object variable /Block variable not set" Can someone help me out with this error ? Thanks in advance

Macro enabled Excel spreadsheet to create folder names list with size in mb

how to get these folders in the same order as they are in the main rather than alphabetical order?

Thanks for the video. However I could not get it to read from my external drive. :(

Please send me the workbook macro file of this video

Hi. I get "variable not defined" when running "xlOp"?

How to use clearcontents and clear only contents from column A starting from cell A3 until last row

This is very useful video. Can you share me the code? Thanks

I'm attempting to retrieve the duration of audio and video files. Have any ideas?

Can you create a macro that can transfer all your VBA knowledge from your brain to my brain?? .... Thanks in advance

Downloadable file available?

Showing error sub or function not defined

how i can get the code

really very useful, but how do I if I just want pdf files?

This is wat I can use, can you sent de code please

Hi can i get this code ?thank you

How to get last modified user ?

not shown in vba code

can we get files dimension from this ?

can you send me this file please

Can u give me this code and excel sheet?

Hi sir Please Add one Row File Duration / File Length