Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Routing code
does something like this work:
Dim sRecipList As String Range("MyRecipients").Select 'Say in cells A1:A10 Do While ActiveCell < "" sRecipList = sRecipList & ", " & ActiveCell ActiveCell.Offset(1, 0).Select Loop 'Get rid of the first "," sRecipList = Mid(sRecipList, 3) MsgBox sRecipList 'Then your code line .Recipients = sRecipList "Mike R." wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |