Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Routing Slips in Excel 2007 - where is "Next Routing Recipient ?" | Excel Discussion (Misc queries) | |||
View Routing Recipients | Excel Programming | |||
Code for Routing command | Excel Programming | |||
Routing - macro to open routing dialog and then stop | Excel Programming | |||
code Help - Routing Recipients | Excel Programming |