Get the LIST of all FILES in a FOLDER – EJ File Manager

Most people wonder why there is no direct way to get a list of files within a folder or directory in Excel. Internet searches give you lengthy and complicated solutions. So I decided to cover this topic in this video, where I'll show you a superfast and easy way to fetch the FILE DETAILS in a folder (and its subfolders). In just a few seconds you can have a neat and professional looking list with all details.

Fully Automatic
Plug and Play

[ketankashliwal]

Hi. That's a very interesting tool you've developed.
I was wondering if there would be anyway to fetch the file data and rename them using this method

[joms]

Hi Sir, I have multiple workbook and I want to put it on 1 master workbook according ng to the 1st column. And must be properly segregated. Can you help how to do? Ty

[karthickgopinath]

Very useful sir. can you share the VBA code so i can use this function in my another workbook. Thanks in advance.

[akshayjagdale]

How to count sub folders automatically from main folder in exel vba

[AshokKumar-srkc]

Please send advanced Excel automatically sent mail in pivot

[seckinbilgic]

I copied to main folder. But it says "Value??"