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

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