ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File Attributes (https://www.excelbanter.com/excel-discussion-misc-queries/12408-file-attributes.html)

dsti3

File Attributes
 
Is there a way to easily take the file name and other file properties such
as, "Date Modified", "Created BY", "File Size", "Application", etc. and
extract these attributes for all files located in a particular directory in
exploring and then have each of these attributes placed in excel in a table
format?

Jim Cone

My Excel add-in "List Files" does that but only provides...
File Path, File Name, File Type, File Size and Date Last Modified.
It creates a hyperlink for each file name and provides an option to
place successive searches all on the same worksheet.

It can also provide a separate listing of Folders/Directories,
and can search multiple drives for that listing.
It is - free - upon direct request, remove xxx from my email address.

Jim Cone
San Francisco, USA
XX


"dsti3" wrote in message
...
Is there a way to easily take the file name and other file properties such
as, "Date Modified", "Created BY", "File Size", "Application", etc. and
extract these attributes for all files located in a particular directory in
exploring and then have each of these attributes placed in excel in a table
format?



All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com