Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Routing slip in Excel 2007

I am trying to code a routing script in Excel 2007. In Excel 2003 it worked
fine and my code was as follows...
ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip
.Recipients = "
.Subject = "Routing: control form"
.Message = ""
.Delivery = xlAllAtOnce
.ReturnWhenDone = False
.TrackStatus = False
End With
ActiveWorkbook.Route

When I try the same code in excel 2007 I receive an error
Run time error 1004 Method HasRoutingSlip of object Workbook failed

Any help would be greatly appreciated. Thanks
Reply
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 Slip Error in Excel 2007 JoeP Excel Programming 0 October 15th 09 04:47 PM
creating a routing slip in Microsoft Excel Bob Excel Discussion (Misc queries) 1 August 17th 09 04:30 PM
How do I set up a routing slip in Office Excel 2007? thecapn32 Excel Discussion (Misc queries) 0 February 9th 07 05:18 PM
Using a Named Range to create routing slip in Excel [email protected] Excel Programming 0 January 8th 07 07:12 PM
Excel Routing Slip Joe[_45_] Excel Programming 0 August 1st 06 10:48 PM


All times are GMT +1. The time now is 03:55 PM.

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

About Us

"It's about Microsoft Excel"