| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file properties with cell data?
I need to fill the file properties like Title, Subject, Author and specially
the Comments with data from different cells. What VBA function do I need to look into? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
file properties with cell data?
With ActiveWorkbook
.BuiltinDocumentProperties("Author") = Range("A1").Value .BuiltinDocumentProperties("Comments") = Range("A2").Value End With etc. -- HTH Bob Phillips "Geto" wrote in message ... I need to fill the file properties like Title, Subject, Author and specially the Comments with data from different cells. What VBA function do I need to look into? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to insert the file properties into a cell for printing. | Excel Discussion (Misc queries) | |||
| How do I display custom file properties in a cell | Excel Discussion (Misc queries) | |||
| How do you use EXCEL formula in properties of file (cell content) | Excel Discussion (Misc queries) | |||
| How can I access/display File -> properties in a cell | Excel Discussion (Misc queries) | |||
| How do I show some of the file properties in a cell in a work she. | Excel Worksheet Functions | |||
Linear Mode
