Thank you very much. i am going to experiment with this tomorrow. It looks
like I may be able to set the comment without even opening the file.
--
Gary''s Student - gsnu2007xx
"Ildhund" wrote:
Quote:
> "Gary''s Student" <GarysStudent@xxxxxx> wrote in
> message news:F3E988CA-3708-4ADF-9B74-42812F79CDE9@xxxxxx
> .... Quote:
> > The filetype, how I created it, or its contents are not important.
> > I am only concerned with the assignment of the comment. The
> > assignment of the
> > comment was manual. I had to manually enter it thru Properties.
> >
> > I want to know if I can assign a comment to a file with a script
> > ( the step 3 part).
>
> You want dsofile: see http://support.microsoft.com/kb/224351. Chip
> Pearson has some typically thorough code (much of it specifically
> designed for XL workbooks) for download at
> http://www.cpearson.com/excel/DocProp.aspx
>
> I'm not sure, but I think that any file type that has a Summary tab
> on its Properties sheet in Explorer can have its properties read and
> written using dsofile.dll.
> --
> Noel
>
>