tag:blogger.com,1999:blog-28492262.post919723584350469519..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: Save and Reopen all Workbooks (Excel VBA)Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-28492262.post-62532473160457470042009-01-07T18:24:00.000-08:002009-01-07T18:24:00.000-08:00Workbooks.Close will close all open workbooks in t...Workbooks.Close will close all open workbooks in that particular Excel instance. <BR/><BR/>If you are using this command from an Open Workbook, it will close that too. If the workbook is not saved, it might prompt for confirmation<BR/><BR/>If the DisplayAlerts is set to false, you can avoid the prompt<BR/><BR/>Application.DisplayAlerts = FalseAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-34451081144589461752009-01-04T17:17:00.000-08:002009-01-04T17:17:00.000-08:00Hi. This is exactly what I want to do. Did I under...Hi. This is exactly what I want to do. Did I understand something wrong?<BR/><BR/>This code will not work for workbooks within the same workbook. <BR/>Execution ends at the "Workbooks.Close" statment.Scotthttps://www.blogger.com/profile/14518280332565568361noreply@blogger.com