Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When saving add automatically contents of a specified cell in document properties
Hello,
Looking for help on the following: When I save my worksheet, I would like the contents of a specified cel to be copied in the document properties. More specifically in the fiel 'key words' in the properties. I tried to create a macro but it does not record to copy text from cell in the field 'key words' in the document properties. Thanks in advance for any help. Regards, Nadi -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When saving add automatically contents of a specified cell indocument properties
Double-click the ThisWorkbook Excel Object, choose workbook from the left
dropdown, choose BeforeSave from the right drop down and insert this one line of code in that macro: BuiltinDocumentProperties(4) = Range("E4") 'Where "E4" is the cell you want in there ALSO: Go to HELP and search for BuiltInDocumentProperties for a description. Search for DocumentProperties Collection to see how to get a list of all properties. TH On 4/23/04 7:00, in article , "Nadia " wrote: Hello, Looking for help on the following: When I save my worksheet, I would like the contents of a specified cell to be copied in the document properties. More specifically in the field 'key words' in the properties. I tried to create a macro but it does not record to copy text from a cell in the field 'key words' in the document properties. Thanks in advance for any help. Regards, Nadia --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert document properties in a cell | Excel Worksheet Functions | |||
Reference the document properties in a cell | Excel Worksheet Functions | |||
Automatically Saving an Excel Document as a Web Page | Excel Discussion (Misc queries) | |||
Automatically Saving an Excel Document as a Web Page | Excel Discussion (Misc queries) | |||
Excel document properties insert into a cell | Excel Discussion (Misc queries) |