LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Routing Slips in Excel 2007 - where is "Next Routing Recipient ?" Dan246 Excel Discussion (Misc queries) 4 May 16th 07 06:58 PM
View Routing Recipients Mike R. Excel Programming 0 January 18th 05 03:19 AM
Code for Routing command Mike R. Excel Programming 2 December 25th 04 01:21 AM
Routing - macro to open routing dialog and then stop Mike R. Excel Programming 1 December 18th 04 02:41 AM
code Help - Routing Recipients Neil[_15_] Excel Programming 1 October 28th 03 08:41 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"