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 Macro to active Menu Command of FileSend ToRouting Recipent

Hello,
I am very determined to get the routing to work. I am trying to eliminate
the need for the user to go to FileSend ToRouting Recipent by create a
macro to do this. I under the code to get to open the routing dialog box:

Application.Dialogs(xlDialogRoutingSlip).Show

The problem is that if I use this, it must skip something that links to the
users outlook. When I run the above code, it opens another dialog box that
asks the user to choose a profile. This will totally confuse my users. Is
there a way to have a macro do the commands of FileSend ToRouting Recipent?
The macro recorder does not for this...

Please help...I would welcome any suggestions to make this work. Thank you,
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
No Send to in File menu Ray[_5_] New Users to Excel 2 November 29th 07 02:56 AM
Send To Recipent as email attachment greyed-out, OE installed m3power Excel Discussion (Misc queries) 1 April 10th 05 10:31 AM
Macro to activate menu command FileRouting Recipent Mike R. Excel Programming 0 January 6th 05 04:05 AM
Routing - macro to open routing dialog and then stop Mike R. Excel Programming 1 December 18th 04 02:41 AM
Can I issue a File, Send To, Mail Recipient command in a macro? Magic Excel Programming 1 November 30th 04 09:20 PM


All times are GMT +1. The time now is 12:06 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"