VBA to extract file names and date modified from all subfolders

[St Vitus Dance]

Hello all

I'm looking for an example of VBA that will extract file names and date modified from files in all subfolders.

Does anyone have an example they could provide?

Thanks very much all

 

[Zot]

VBA to get list of file names in a folder with last modified date

Hello, I have been looking for a VBA code that list all the file names in a specific folder with their last modified date or the date when the file were moved in that folder. I have looked for code on

answers.microsoft.com

 

[Fluff]

Have a look here

List the Files in a Folder and its SubFolders using the FileSystemObject | xl-central.com

List the files in a folder and its subfolders using the FileSystemObject in Excel VBA.

www.xl-central.com

 

[St Vitus Dance]

Have a look here

List the Files in a Folder and its SubFolders using the FileSystemObject | xl-central.com

List the files in a folder and its subfolders using the FileSystemObject in Excel VBA.

www.xl-central.com

Thanks very much!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Nikkii]

Have a look here

List the Files in a Folder and its SubFolders using the FileSystemObject | xl-central.com

List the files in a folder and its subfolders using the FileSystemObject in Excel VBA.

www.xl-central.com

I got this error when running the program, what did I do wrong?

 

[Fluff]

Sounds like you didn't set the references as it says at the top of the linked page

Note that the FileSystemObject is a component of the Microsoft Scripting library, which requires Excel 2000 or later. Also, you'll need to set a reference to Microsoft Scripting Runtime by using Tools > References in the Visual Basic Editor (Alt+F11).