Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Save without the Save Message
I am writing a macro that will ultimately close the workbook. However, I want
to save changes but I do not want the user prompted with the Do You Want To Save Changes message. I simply want the workbook to save and close. I know about DisplayAlerts -- but it appears that setting this to false stops the Save message but does not keep the changes. Can anybody help? Thanks so much. Ellen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Save without the Save Message
Try
application.save application.quit (or application.close, depending upon whether you want to close excel completely or not). hope this helps, -Chad "Ellen G" wrote: I am writing a macro that will ultimately close the workbook. However, I want to save changes but I do not want the user prompted with the Do You Want To Save Changes message. I simply want the workbook to save and close. I know about DisplayAlerts -- but it appears that setting this to false stops the Save message but does not keep the changes. Can anybody help? Thanks so much. Ellen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Save without the Save Message
Save the workbook first by calling the Save or SaveAs method. Then you can
immediately close it and you won't get the prompt. "Ellen G" wrote: I am writing a macro that will ultimately close the workbook. However, I want to save changes but I do not want the user prompted with the Do You Want To Save Changes message. I simply want the workbook to save and close. I know about DisplayAlerts -- but it appears that setting this to false stops the Save message but does not keep the changes. Can anybody help? Thanks so much. Ellen |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Save without the Save Message
Hi Ellen
ActiveWorkbook.Close SaveChanges:=TRUE -- Thanks, Shane Devenshire "Ellen G" wrote: I am writing a macro that will ultimately close the workbook. However, I want to save changes but I do not want the user prompted with the Do You Want To Save Changes message. I simply want the workbook to save and close. I know about DisplayAlerts -- but it appears that setting this to false stops the Save message but does not keep the changes. Can anybody help? Thanks so much. Ellen |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Save without the Save Message
I feel so stupid. I actually figured this out just before I saw everyone's
input. THANKS EVERYBODY! "Chad" wrote: Try application.save application.quit (or application.close, depending upon whether you want to close excel completely or not). hope this helps, -Chad "Ellen G" wrote: I am writing a macro that will ultimately close the workbook. However, I want to save changes but I do not want the user prompted with the Do You Want To Save Changes message. I simply want the workbook to save and close. I know about DisplayAlerts -- but it appears that setting this to false stops the Save message but does not keep the changes. Can anybody help? Thanks so much. Ellen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display message during save operation | Excel Discussion (Misc queries) | |||
Formula Causing a Save Error Message | Excel Worksheet Functions | |||
why do I get a message that says save a copy or overwrite changes | Excel Discussion (Misc queries) | |||
When I save a file I consistently get a message about saving a co. | Excel Discussion (Misc queries) | |||
When I try to save a workbook, I get the message "document has no. | Excel Discussion (Misc queries) |