Re: Tricky Question Re: File Properties

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/03/04 

Date: Tue, 3 Feb 2004 15:03:31 -0000

Neil,

Not sure what the difficulty is, but this is how to set a property

    With ActiveWorkbook.BuiltinDocumentProperties
        .Item("Subject") = Active***.Range("A1").Value
    End With 

-- 
HTH
Bob Phillips
    ... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Neil Rogers" <neil_rogers@huntsman.com> wrote in message
news:921801c3ea61$37a31db0$a001280a@phx.gbl...
> Hi, is there anyway to take some values from a
> spread*** and stiock them into the file properties
> summary for the file, like Subject, Author, Manager,
> Topic etc. I would like to throw together a little form
> that is displayed before Close to force people to enter
> the details about the file that will then be picked up
> during the indexing process.
>
> Best regards
>
>
>
>
>
Quantcast