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