Save= False Question
Hi:
I have a macro that includes the following: ActiveWorkbook.Close Save = False I had anticipated that this wold result in the spreadsheet being closed but NOT being saved. However, it appears that its being saved as its being closed. Can someone suggest a reason, and more important, a way to prevent it being saved! Thanks John Baker |
Save= False Question
Hi John,
ActiveWorkbook.Close Save = False I had anticipated that this wold result in the spreadsheet being closed but NOT being saved. However, it appears that its being saved as its being closed. Can someone suggest a reason, and more important, a way to prevent it being saved! The proper syntax is: ActiveWorkbook.Close SaveChanges:= False Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Save= False Question
John
ActiveWorkbook.Close false works for me or ActiveWorkbook.Close savechanges:=false you could also try adding ActiveWorkbook.saved = true before you close to clear the 'needs saving' flag I also open stuff read only where possible Cheers Simon -----Original Message----- Hi: I have a macro that includes the following: ActiveWorkbook.Close Save = False I had anticipated that this wold result in the spreadsheet being closed but NOT being saved. However, it appears that its being saved as its being closed. Can someone suggest a reason, and more important, a way to prevent it being saved! Thanks John Baker . |
Save= False Question
Jan:
The macro is as follows now and it STILL saves the spreadsheet! Any suggestions? : Sub InstallNo() ' ' InstallNo Macro ' Macro recorded 07/02/2004 by John H Baker ' Msgbox ("You have elected not to install the new version of the spreadsheet. If you change your mind you may reopen this sheet and restart the installation process later.") ActiveWorkbook.Close SaveChanges = False ' End Sub Jan Karel Pieterse wrote: Hi John, ActiveWorkbook.Close Save = False I had anticipated that this wold result in the spreadsheet being closed but NOT being saved. However, it appears that its being saved as its being closed. Can someone suggest a reason, and more important, a way to prevent it being saved! The proper syntax is: ActiveWorkbook.Close SaveChanges:= False Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Save= False Question
Sorry I found the mistake. I had not put a : before the = sign! Its unusual to require that..I have used just = in many other situations and it works just fine. Best John John Baker wrote: Jan: The macro is as follows now and it STILL saves the spreadsheet! Any suggestions? : Sub InstallNo() ' ' InstallNo Macro ' Macro recorded 07/02/2004 by John H Baker ' Msgbox ("You have elected not to install the new version of the spreadsheet. If you change your mind you may reopen this sheet and restart the installation process later.") ActiveWorkbook.Close SaveChanges = False ' End Sub Jan Karel Pieterse wrote: Hi John, ActiveWorkbook.Close Save = False I had anticipated that this wold result in the spreadsheet being closed but NOT being saved. However, it appears that its being saved as its being closed. Can someone suggest a reason, and more important, a way to prevent it being saved! The proper syntax is: ActiveWorkbook.Close SaveChanges:= False Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
All times are GMT +1. The time now is 10:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com