Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message still appears with DisplayAlerts = False & SaveChanges:=Fa
In an Excel 2003 macro, I have 3 workbooks, each of which I close with this
code: ActiveWindow.Close SaveChanges:=False This has run for months without incident but now, in each instance, pops up a form entitled "Document modified," with the prompt: "The active document has been changed. Save Changes?" So, I added, before the Close method: "Application.DisplayAlerts = False". The message still appears when it hits the Close. The macro was originally written in Excel 2003 & all the workbooks invloved are Excel 97-2003 .xls files. However, I am now using Excel 2007, though the primary user of the workbooks & the macro is still using 2003. I had made some changes to the macro through my Excel 2007. It had the .xls open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm. Windows Explorer shows it as file type "Excel 97-2003 Worksheet." Is there something in the 2003 - 2007 relationship that might cause this problem? Thanks, Will |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message still appears with DisplayAlerts = False & SaveChanges:=Fa
If you are not saving changes then you can also add this line: VBA Code: -------------------- Activeworkbook.Saved=TRUE -------------------- Excel will think it has already been saved and you should not be alerted. wpiet;661538 Wrote: In an Excel 2003 macro, I have 3 workbooks, each of which I close with this code: ActiveWindow.Close SaveChanges:=False This has run for months without incident but now, in each instance, pops up a form entitled "Document modified," with the prompt: "The active document has been changed. Save Changes?" So, I added, before the Close method: "Application.DisplayAlerts = False". The message still appears when it hits the Close. The macro was originally written in Excel 2003 & all the workbooks invloved are Excel 97-2003 .xls files. However, I am now using Excel 2007, though the primary user of the workbooks & the macro is still using 2003. I had made some changes to the macro through my Excel 2007. It had the xls open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm. Windows Explorer shows it as file type "Excel 97-2003 Worksheet." Is there something in the 2003 - 2007 relationship that might cause this problem? Thanks, Will -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184739 Excel Live Chat |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message still appears with DisplayAlerts = False & SaveChanges
Thanks, Simon. That took care of it.
Any idea why that was popping up, when it never had before in all the months it's been running? -- Will "Simon Lloyd" wrote: If you are not saving changes then you can also add this line: VBA Code: -------------------- Activeworkbook.Saved=TRUE -------------------- Excel will think it has already been saved and you should not be alerted. wpiet;661538 Wrote: In an Excel 2003 macro, I have 3 workbooks, each of which I close with this code: ActiveWindow.Close SaveChanges:=False This has run for months without incident but now, in each instance, pops up a form entitled "Document modified," with the prompt: "The active document has been changed. Save Changes?" So, I added, before the Close method: "Application.DisplayAlerts = False". The message still appears when it hits the Close. The macro was originally written in Excel 2003 & all the workbooks invloved are Excel 97-2003 .xls files. However, I am now using Excel 2007, though the primary user of the workbooks & the macro is still using 2003. I had made some changes to the macro through my Excel 2007. It had the .xls open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm. Windows Explorer shows it as file type "Excel 97-2003 Worksheet." Is there something in the 2003 - 2007 relationship that might cause this problem? Thanks, Will -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184739 Excel Live Chat . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If you are not saving changes then you can also add this line:VBA
Awesome hint. Thankyou
On Thursday, March 04, 2010 3:55 PM wpiet wrote: In an Excel 2003 macro, I have 3 workbooks, each of which I close with this code: ActiveWindow.Close SaveChanges:=False This has run for months without incident but now, in each instance, pops up a form entitled "Document modified," with the prompt: "The active document has been changed. Save Changes?" So, I added, before the Close method: "Application.DisplayAlerts = False". The message still appears when it hits the Close. The macro was originally written in Excel 2003 & all the workbooks invloved are Excel 97-2003 .xls files. However, I am now using Excel 2007, though the primary user of the workbooks & the macro is still using 2003. I had made some changes to the macro through my Excel 2007. It had the .xls open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm. Windows Explorer shows it as file type "Excel 97-2003 Worksheet." Is there something in the 2003 - 2007 relationship that might cause this problem? Thanks, Will On Thursday, March 04, 2010 4:19 PM Simon Lloyd wrote: If you are not saving changes then you can also add this line: VBA Code: -------------------- Activeworkbook.Saved=TRUE -------------------- Excel will think it has already been saved and you should not be alerted. wpiet;661538 Wrote: In an Excel 2003 macro, I have 3 workbooks, each of which I close with this code: ActiveWindow.Close SaveChanges:=False This has run for months without incident but now, in each instance, pops up a form entitled "Document modified," with the prompt: "The active document has been changed. Save Changes?" So, I added, before the Close method: "Application.DisplayAlerts = False". The message still appears when it hits the Close. The macro was originally written in Excel 2003 & all the workbooks invloved are Excel 97-2003 .xls files. However, I am now using Excel 2007, though the primary user of the workbooks & the macro is still using 2003. I had made some changes to the macro through my Excel 2007. It had the .xls open in Compatibility Mode & I saved it as .xls format, not 2007 .xlsm. Windows Explorer shows it as file type "Excel 97-2003 Worksheet." Is there isomething in the 2003 - 2007 relationship that might cause this problem? Thanks, Will -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184739 Excel Live Chat On Friday, March 05, 2010 11:53 AM wpiet wrote: Thanks, Simon. That took care of it. Any idea why that was popping up, when it never had before in all the months it is been running? -- Will "Simon Lloyd" wrote: wpiet;661538 Wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Update Links Message is False but Always Appears | Excel Discussion (Misc queries) | |||
VBA - Do Loop or SaveChanges = false | Excel Discussion (Misc queries) | |||
Problem with Activeworkbook.Close SaveChanges:=False | Excel Programming | |||
Where to put DisplayAlerts = False | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming |