Share via


Workbook.RoutingSlip Property (2007 System)

Gets a RoutingSlip object that represents the routing slip for the workbook.

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 ReadOnly Property RoutingSlip As RoutingSlip
'Usage
Dim instance As Workbook 
Dim value As RoutingSlip 

value = instance.RoutingSlip
[BrowsableAttribute(false)]
public RoutingSlip RoutingSlip { get; }
[BrowsableAttribute(false)]
public:
property RoutingSlip^ RoutingSlip {
    RoutingSlip^ get ();
}
public function get RoutingSlip () : RoutingSlip

Property Value

Type: RoutingSlip
A RoutingSlip object that represents the routing slip for the workbook.

Remarks

Reading this property if there is no routing slip causes an exception to be thrown (check the HasRoutingSlip property first).

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

See Also

Reference

Workbook Class

Workbook Members

Microsoft.Office.Tools.Excel Namespace