Update the comment of a filename

[Guest]

Hi,

Thanks for stopping by.

Need to know how to read the author & comment field of a file

Once read, need to update the comment.

Needs to be done in VBA in access

Examples of files c:\Test.txt
c:\Testxls.xls
c:\Textword.doc

etc

Thanks

trev

 

[Douglas J. Steele]

AFAIK, you can't put those kinds of comments in Text files.

For Office files, you could use Automation. Instantiate Word or Excel, open
the document and then look at the properties of the document.