Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close workbook without being prompted to save in VBA
I am using the following code to close and save a workbook:
Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=True I can't seem to get this to work without prompting me to save, even though I did application.displayalerts = false and I told it to save in the active.workbook.close command. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close workbook without being prompted to save in VBA
On Dec 19, 10:36 pm, J Wait wrote:
I am using the following code to close and save a workbook: Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=True I can't seem to get this to work without prompting me to save, even though I did application.displayalerts = false and I told it to save in the active.workbook.close command. I made it work with ActiveWorkbook.Save ActiveWorkbook.Close /Tommy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close workbook without being prompted to save in VBA
Do you have any "on close" event code. If so then it may be altering the
workbook which will prompt the save message. You can use Activeworkbook.Saved = true to make the application believe that a save is not necessary... -- HTH... Jim Thomlinson "J Wait" wrote: I am using the following code to close and save a workbook: Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=True I can't seem to get this to work without prompting me to save, even though I did application.displayalerts = false and I told it to save in the active.workbook.close command. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close workbook without being prompted to save in VBA
I tried what you said to begin with, and even though I told it to save before
I told it to close, it still prompted me to save on the close command. I don't know what else to try. I've never run into this problem before. I have also tried "ActiveWorkbook.Close True", and it still prompts me to save. To answer Jim's question, I don't have any "on close" event code, so I can't try what he suggested. Please let me know if you have any other ideas I could try. I'm hung up on this one piece of the code! "TG" wrote: On Dec 19, 10:36 pm, J Wait wrote: I am using the following code to close and save a workbook: Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=True I can't seem to get this to work without prompting me to save, even though I did application.displayalerts = false and I told it to save in the active.workbook.close command. I made it work with ActiveWorkbook.Save ActiveWorkbook.Close /Tommy |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close workbook without being prompted to save in VBA
On Dec 19, 10:59 pm, J Wait wrote:
I tried what you said to begin with, and even though I told it to save before I told it to close, it still prompted me to save on the close command. I don't know what else to try. I've never run into this problem before. I have also tried "ActiveWorkbook.Close True", and it still prompts me to save. To answer Jim's question, I don't have any "on close" event code, so I can't try what he suggested. Please let me know if you have any other ideas I could try. I'm hung up on this one piece of the code! "TG" wrote: On Dec 19, 10:36 pm, J Wait wrote: I am using the following code to close and save a workbook: Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=True I can't seem to get this to work without prompting me to save, even though I did application.displayalerts = false and I told it to save in the active.workbook.close command. I made it work with ActiveWorkbook.Save ActiveWorkbook.Close /Tommy The reason could be a formula containing NOW() or TODAY() as these are changing ' on the fly' and therefore the worksheet believe it has changed, and must be saved on closing.. Maybe this will work, I haven't tried yet ActiveWorkbook.Save ActiveWorkbook.Saved ActiveWorkbook.Close /Tommy |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close workbook without being prompted to save in VBA
Thank you so much Tommy and Jim! Here's what ended up working:
ActiveWorkbook.Save ActiveWorkbook.Saved = True ActiveWorkbook.Close You solved a huge headache for me! Thanks! "TG" wrote: On Dec 19, 10:59 pm, J Wait wrote: I tried what you said to begin with, and even though I told it to save before I told it to close, it still prompted me to save on the close command. I don't know what else to try. I've never run into this problem before. I have also tried "ActiveWorkbook.Close True", and it still prompts me to save. To answer Jim's question, I don't have any "on close" event code, so I can't try what he suggested. Please let me know if you have any other ideas I could try. I'm hung up on this one piece of the code! "TG" wrote: On Dec 19, 10:36 pm, J Wait wrote: I am using the following code to close and save a workbook: Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=True I can't seem to get this to work without prompting me to save, even though I did application.displayalerts = false and I told it to save in the active.workbook.close command. I made it work with ActiveWorkbook.Save ActiveWorkbook.Close /Tommy The reason could be a formula containing NOW() or TODAY() as these are changing ' on the fly' and therefore the worksheet believe it has changed, and must be saved on closing.. Maybe this will work, I haven't tried yet ActiveWorkbook.Save ActiveWorkbook.Saved ActiveWorkbook.Close /Tommy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - No Longer Prompted to Save When I Close File | Excel Discussion (Misc queries) | |||
Open New Workbook / Save and Close Current Workbook | Excel Programming | |||
"Save" macro problem, still prompted to save when closing workbook (?) | Excel Programming | |||
Help on Workbook close and workbook save events | Excel Programming | |||
filling a combobox (without being prompted to save the workbook EVERY time its opened | Excel Programming |