List Files In Subfolders with Modified Date

[blimbert]

Hello - I am trying to obtain a file listing of all files in a network folder, and multiple layers of subfolders.

Requirements:

1. Return filename, file path, file type, and file last modified date to an excel sheet
2. Evaluate all files within all subfolders. In other words if there are nested subfolders, evaluate the files within every subfolder and its subfolders
3. Obtain the file information if the last modified date is after a certain date (eg >=1/1/2022)
4. Obtain the file information if the file type is a certain file type (eg .xlsx)

I have tried various code snippets from various sources and have not yet found one that works as desired.

Could you please help?

 

[pjmorris]

Use Powerquery - 20000 files in about 3 seconds, over 41000 in 7. Only thing to watch is path length, but then I was search a cloud store.

 

[JEC]

Yes, power query is also easy to use

 

[AC PORTA VIA]

JEC your code is great for me.
is there way to get hyperlink to file instead of just path. or both hyperlink to each file and folder of the file

 

[Sufiyan97]

Use Powerquery - 20000 files in about 3 seconds, over 41000 in 7. Only thing to watch is path length, but then I was search a cloud store.

Yes, I did use it when with code taking much time,

it took around 10-15 sec to load 75K+ rows
Power query is great.

 

[AC PORTA VIA]

I just made macro to run power query and it took 5 seconds for 22400 files from my flash drive path
Awsome