Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close(savechanges,filename,routeworkbook)
in vba i am trying to close an active workbook
in this statement; close(savechanges,filename,routeworkbook) what is the meaning of "routeworkbook" ? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
close(savechanges,filename,routeworkbook)
Hi,
I think Routeworkbook means "Send me to the next recipient, that yo specified?". If you set it to false it won't go anywhere, as long as n routing slpi has been attached. If you omit it, and there is a routin slip attached, I think a dialogue box is displayed asking the user i they want to route the workbook to the next recipient. Cheer -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
close(savechanges,filename,routeworkbook)
It's used to route the workbook, using the workbook's current routing slip.
Must admit I have never used it from within VBA but usually from the Excel File-Send To menu option Cheers Nigel "Zygoid " wrote in message ... in vba i am trying to close an active workbook in this statement; close(savechanges,filename,routeworkbook) what is the meaning of "routeworkbook" ? --- Message posted from http://www.ExcelForum.com/ ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA - Do Loop or SaveChanges = false | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
how to recognize SaveChanges Parameter | Excel Programming |