Routing slip in Excel 2007

J

JoeP

I am trying to code a routing script in Excel 2007. In Excel 2003 it worked
fine and my code was as follows...
ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip
.Recipients = "(e-mail address removed)"
.Subject = "Routing: control form"
.Message = ""
.Delivery = xlAllAtOnce
.ReturnWhenDone = False
.TrackStatus = False
End With
ActiveWorkbook.Route

When I try the same code in excel 2007 I receive an error
Run time error 1004 Method HasRoutingSlip of object Workbook failed

Any help would be greatly appreciated. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Routing Slip Error in Excel 2007 0
Excel 2007 Routing workbook to Outlook 1
Using a Named Range to create routing slip in Excel 0
How dynamically create routing slip based on names in specific cel 1
Routing slips in Excel 2007 1
I need help with Code for a Command button I need the were is says Username to pull this data from a 1
Excel Routing Slip 0
.HasRoutingSlip 0

Top