Subject Property

Applies To

AddIn Object, Mailer Object, RoutingSlip Object, Workbook Object.

Description

Returns or sets the subject for the object, as a string. Read-only for AddIn, read-write for RoutingSlip and Workbook.

Remarks

In Microsoft Excel for Windows 95, this property has been replaced by a built-in OLE document property. For more information about OLE document properties, see BuiltinDocumentProperties.

The subject for the RoutingSlip object is used as the subject of mail messages used to route the workbook. PowerTalk requires that a subject be present before the mailer can be sent.

You cannot use this property with an AddIn object that represents an XLL file or an add-in that was created with the Microsoft Excel 4.0 macro language.

See Also

Author Property, Comments Property, Keywords Property, Title Property.

Example

This example sets the subject for the active workbook.

ActiveWorkbook.Subject = "Data for my presentation in April"

This example sets the subject for a routing slip for the workbook BOOK1.XLS. To run this example, you must have Microsoft Mail for Windows or Microsoft Mail for the Macintosh installed.

Workbooks("BOOK1.XLS").HasRoutingSlip = True
With Workbooks("BOOK1.XLS").RoutingSlip
    .Delivery = xlOneAfterAnother
    .Recipients = Array("Adam Bendel", "Jean Selva", "Bernard Gabor")
    .Subject = "Here is BOOK1.XLS"
    .Message = "Here is the workbook. What do you think?"
End With
Workbooks("BOOK1.XLS").Route

This example sets the subject for a mailer in the PowerTalk mail system (Macintosh only). To run this example, you must have the PowerTalk mail system installed.

With Workbooks(1)
    .HasMailer = True
    With .Mailer
        .Subject = "Here is the workbook"
        .ToRecipients = Array("Jean")
        .CCRecipients = Array("Adam", "Bernard")
        .BCCRecipients = Array("Chris")
        .Enclosures = Array("TestFile")
    End With
    .SendMailer
End With