close(savechanges,filename,routeworkbook)

  • Thread starter Thread starter Zygoid
  • Start date Start date
Z

Zygoid

in vba i am trying to close an active workbook

in this statement;

close(savechanges,filename,routeworkbook)

what is the meaning of "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
 
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
 
Back
Top