Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
My worksheet uses Routing and I would like to pull the Routing Recepients names off of the routing slip and put them somewhere on the worksheet to everyone can see who the worksheet will be routed to. I have read the help file on this, but I am a little confused. Below is what Help says. I would just like code to retreive the routing recipients. I think my code should be something like: Names = ThisWorkbook.RoutingSlip.Recepients, but I am confused. help please..... Syntax expression.Recipients(Index) expression Required. An expression that returns a RoutingSlip object. Index Optional Variant. The recipient. If this argument isnt specified, the Recipients property returns (or can be set to) an array that contains all recipients. Remarks The order of the recipient list defines the delivery order if the routing delivery option is xlOneAfterAnother. If a routing slip is in progress, only those recipients who havent already received and routed the document are returned or set. -- Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retrieving file | Excel Discussion (Misc queries) | |||
retrieving information | Excel Discussion (Misc queries) | |||
Retrieving formulae | Excel Discussion (Misc queries) | |||
Help Please!, Retrieving E-Mail | Excel Programming | |||
Retrieving URL | Excel Programming |