| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to change file properties
I am trying to create a macro that will insert a block of text into the
"comments" field in the file properties. in word this is done by the following block With Dialogs(wdDialogFileSummaryInfo) .Comments = " some text " .Execute End With how can I do this in excel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to change file properties
wb.Comments = "Hello"
where wb refers to a workbook, eg ThisWorkbook, ActiveWorkbook, Workbooks("Book1.xls") Regards, Peter T "TomH" wrote in message ... I am trying to create a macro that will insert a block of text into the "comments" field in the file properties. in word this is done by the following block With Dialogs(wdDialogFileSummaryInfo) .Comments = " some text " .Execute End With how can I do this in excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change properties on | Excel Programming | |||
| Change combobox properties | Excel Programming | |||
| How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
| Properties transferring from excel cells to word file properties | Excel Programming | |||
| MSCAL.Calendar Excel Cannot change Properties Using Macro | Excel Programming | |||
Linear Mode
