ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Routing Slip Error in Excel 2007 (https://www.excelbanter.com/excel-programming/434966-routing-slip-error-excel-2007-a.html)

JoeP

Routing Slip Error in Excel 2007
 
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



All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com