Dear Yeghi,Hi,
Is there anyway that you can export the file explorer's results to an excel file, and not just copy "Path"?
On other words, to document the list of files, with their details as they come up in file explorer screen, in an Excel file.
Much appreciated
Yeghi
Dear Yeghi,Hi Yousuf,
thank you so much for your feedback. I was just wondering if there was a simple way of capturing the results in the file Explorer, as is, into Excel. "Copying as path," does not include the additional info. such as size, last modified, etc.
"Copy"ing the results, it copy the files as they are and not just the list.
So, not using the cmd window, and not using snip, no need the image, is there anyway we can capture the list from file explorer into Excel?
Thank you,
Yeghi
Sub ShowFolderSize(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(filespec)
s = UCase(f.Name) & " uses " & f.size & " bytes."
MsgBox s, 0, "Folder Size Info"
End Sub