Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky Question File Properties
Hi, is there anyway to take some values from a
spreadsheet 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky Question File Properties
Neil,
Not sure what the difficulty is, but this is how to set a property With ActiveWorkbook.BuiltinDocumentProperties .Item("Subject") = Activesheet.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" wrote in message ... Hi, is there anyway to take some values from a spreadsheet 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Macro Question | Excel Worksheet Functions | |||
Tricky counting question | Excel Discussion (Misc queries) | |||
Tricky comparing question | Excel Worksheet Functions | |||
Tricky Question | Excel Worksheet Functions | |||
rota question - very tricky... | Excel Discussion (Misc queries) |