Exporting from MS Explorer

[ChrisChamberlain]

Hi Does anyone know how to do this....
From Windows explorer I can see attributes of files that relate to MS office (Subject, Author etc. etc.)
I need a way to put these details into a file
I can use the dos command :- DIR *.Doc >File.txt
However I cannot find a way of obtaining the extra attributes.
My ultimat goal is to load the details into a database to as a tool to see what files have the attributes filled, what documents have been updated etc. etc.

Thanks
Chris

 

[linney]

Explorer (I believe) cannot access these hidden streams the way you want to in so far as they are embedded into the original file as a Alternate data Stream.

Have a look at this article and see if the tools listed later on are of use to you?

Hide sensitive files with Alternate Data Streams

http://windowssecrets.com/links/gkl.../?url=WindowsSecrets.com/issue/071206/?u=$P20

InfoTip question
thread779-1464355

 

[ChrisChamberlain]

Actually MS Explorer can see these attributes, just right click the headings of the file details panel, and you can choose a huge amount of them. I just need a way of exporting these details...

 

[mscallisto]

Using Excel you can capture much of this info with a VBA macro to your spreadsheet.

Example:

http://www.techbookreport.com/tutorials/fso2.html

scroll down to the paragraph FILESfor an example.

if you're not familiar with VBA you can re-post in the VBA forum 707

http://www.tek-tips.com/threadminder.cfm?pid=707

sam