Extract File Properties>Description>Comments 1

[rockfish12]

Is there a way to extract any/all of the File Description elements for a given file?

To further clarify, in Win2K - and maybe other Win OS's (?) - , when you right-click on a file to get its properties, and click on the Summary tab, there are a number of Description elements that users can type stuff in, including Title, Subject, Category, Keyword, Comments, etc...

I have some plain text files (.txt) where a user has entered values in the Comments portion of the File Description. Can I get at these programmatically (using VBA, ideally)? I'm trying to write the name of the file and the associated comments to a database.

Any ideas? (Sorry if not right forum...)

 

[vb5prgrmr]

check this out. I think this is what you need.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q224351&

Good Luck

 

[rockfish12]

Thanks, vb5prgrmr...had to modify to suit Access VBA environment, and it worked great!