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
|