Generate file list with name, date, size, etc

I have a folder containing about 100,000 files and subfolders. Approximately 20% of the files are duplicates. I would like to create a list of all the files with some details so that I can sort through and identify which ones are duplicates, then create a batch file to delete them. Does anyone know how to get a file list with additional details, like size, modified date, etc, into an excel format?

This will give you the file names only in a folder.
I think the earlier attachment will be better for your need

PHP Code: 

Sub ListAllFile()
     
    Dim objFSO As Object
    Dim objFolder As Object
    Dim objFile As Object
    Dim ws As Worksheet
     
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    Set ws = Worksheets("Sheet2")

     
     'Get the folder object associated with the directory
    Set objFolder = objFSO.GetFolder("D:\")
    ws.Cells(1, 1).Value = "The files found in " & objFolder.Name & "are:"
     
     'Loop through the Files collection
    For Each objFile In objFolder.Files
        ws.Cells(ws.UsedRange.Rows.Count + 1, 1).Value = objFile.Name
    Next
     
     'Clean up!
    Set objFolder = Nothing
    Set objFile = Nothing
    Set objFSO = Nothing
     
End Sub 


Worked like a charm, thanks akhileshgs!