![]() |
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