Re: Displaying File 'Comments' in (Properties > Details) with Excel VBA
I hope this isn't too old of a thread. I'm trying to use the code in the forum but none of it is working and I'm not quite understanding the link posted by snb.
I'm attempting to get the Extended Properties as well but nothing I try works even though the code here was verified as working.
Sub FileDetails() 'Pulls in name for each file in specified folder location Dim ctr As Integer Dim path As Variant Dim file As Variant ctr = 1 'path = "J:\DefaultManagement\Timeline Management\Foreclosure Bid Approval\JFIGS\ " ' Path should always contain a '\' at end path = "P:\Rejected\" file = Dir(path) ' Retrieving the first entry. Do Until file = "" ' Start the loop. Worksheets("Folder").Cells(ctr + 1, 1).Value = file ctr = ctr + 1 file = Dir() ' Getting next entry. Loop End Sub