File Summary Comment

[Guest]

Hi All,

Thanks for your help on this one.

I am trying to update the comment field through access code to 250 different
types of file.

I have tried to reference the code but I can't do it.

I know I can do it manually but I would like to have it in code. To read it
& also to update it. We are talking file comment and not comments inside the
file.

Look forward to hearing from you

Regards

Trev

 

[John Nurick]

Hi Trever,

You seem to be referring to the "comments" field you can see by
right-clicking a file in a My Computer window, selecting Properties and
clicking on the Summary tab.

No doubt it can be done, but it's not going to be simple and there's no
built-in function for it in VBA.

The problem is that some kinds of file (e.g. Word and Excel documents)
can store comments and other file properties inside themselves, while
for others (e.g. text files) there is no provision to do that and the
properties are stored separately by the file system (and not all Windows
file systems have that ability).

I suspect that (for a further complication) there are at least three
ways of storing comments within the document, requiring different
techniques to access them. So I'd start by searching for an API that
gives access to the stuff in the File|Properties facility in My
Computer, because that seems to handle the various different situations.

I'd also search (at groups.google.com) the archive of the newsgroup
microsoft.public.windows.file_system, and maybe post the question in
that group.

Good luck!