View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike R. Mike R. is offline
external usenet poster
 
Posts: 59
Default View Routing code

Hello,
I am using a workbook with routing. Once the user sets up the routing, I
would like to display the routing recipients on the actual worksheet. Here
is the vb routing code, I just can not figure out how to pull the recipients
out if they are not stated in the code, rather the user sets it up:
Workbooks("BOOK1.XLS").HasRoutingSlip = True
With Workbooks("BOOK1.XLS").RoutingSlip
.Recipients = Array("Adam Bendel", _
"Jean Selva", "Bernard Gabor")
End With

If the above example, the vb codes set up the recipients, but in my book,
the user will set it up. Help please... thanks!
mike