Routing Slip Error in Excel 2007

J

JoeP

I used the HasRoutingSlip Property in a macro for Excel 2003. after
upgrading to Excel 2007 the HasRoutingSlip macro give me the message:

Run-time error '1004':
Method 'HasRoutingSlip' of object '_Workbook' failed

Can anyone tell me what in might need to do differently in Excel 2007 to get
this macro to work. Here is the code...

ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip
.Recipients = Array("zrbur it inventory control")
.Subject = "Routing: inventory control form"
.Message = ""
.Delivery = xlAllAtOnce
.ReturnWhenDone = False
.TrackStatus = False
End With
ActiveWorkbook.Route

Thanks for any help.

JoeP
 

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 in Excel 2007 0
.HasRoutingSlip 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
I need help with Code for a Command button I need the were is says Username to pull this data from a 1
Routing slips in Excel 2007 1
Excel Routing Slip 0

Top