Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a routing slip in Microsoft Excel | Excel Discussion (Misc queries) | |||
How do I set up a routing slip in Office Excel 2007? | Excel Discussion (Misc queries) | |||
Using a Named Range to create routing slip in Excel | Excel Programming | |||
Excel Routing Slip | Excel Programming | |||
routing slip | Excel Programming |