Workbook.Subject Property (2007 System)
Gets or sets the subject for the mailer or routing slip.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public Property Subject As String
'Usage
Dim instance As Workbook
Dim value As String
value = instance.Subject
instance.Subject = value
[BrowsableAttribute(false)]
public string Subject { get; set; }
[BrowsableAttribute(false)]
public:
property String^ Subject {
String^ get ();
void set (String^ value);
}
public function get Subject () : String
public function set Subject (value : String)
Property Value
Type: System.String
The subject for the mailer or routing slip.
Remarks
The subject for the RoutingSlip is used as the subject for mail messages used to route the workbook.
Examples
The following code example checks the value of the Routed property to determine whether the workbook has been routed. If the workbook has not been routed, then the example sets the HasRoutingSlip property to true, sets the Subject property to a subject line for the routing slip, and then uses the RoutingSlip property to adjust the delivery type, message, and the recipients. Finally, the example calls the Route method to route the workbook.
This example is for a document-level customization.
Private Sub RouteWorkbook()
If Not Me.Routed Then
Me.HasRoutingSlip = True
Me.Subject = "Here is the forecast spreadsheet."
Dim routingSlip As Excel.RoutingSlip = Me.RoutingSlip
routingSlip.Delivery = Excel.XlRoutingSlipDelivery.xlOneAfterAnother
routingSlip.Message = "Please review and provide your feedback."
routingSlip.Recipients = New String() _
{"Don Hall", "Sydney Higa", "Ron Gabel"}
Me.Route()
End If
End Sub
private void RouteWorkbook()
{
if (!this.Routed)
{
this.HasRoutingSlip = true;
this.Subject = "Here is the forecast spreadsheet.";
Excel.RoutingSlip routingSlip = this.RoutingSlip;
routingSlip.Delivery = Excel.XlRoutingSlipDelivery.xlOneAfterAnother;
routingSlip.Message = "Please review and provide your feedback.";
routingSlip.set_Recipients(0,
new string[] { "Don Hall", "Sydney Higa", "Ron Gabel" });
this.Route();
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.