ActiveWorkbook.Close SaveChanges:=False End Sub Ø本节内容参考程序文件：Chapter03-2.xlsm 9保存并关闭工作簿Close a Workbook after Saving Sub mynzvba_close_workbook()Dim wbCheck As String wbCheck = Dir(ThisWorkbook.Path & "\myFile.xlsx")If wbCheck = "" Then Workbooks("工作簿1").Close _...
Sub mynzvba_close_Activeworkbook() ActiveWorkbook.Close SaveChanges:=False End Sub 本节内容参考程序文件:Chapter03-2.xlsm 9 保存并关闭工作簿Close a Workbook after Saving Sub mynzvba_close_workbook() Dim wbCheck As String wbCheck = Dir(ThisWorkbook.Path & "\myFile.xlsx") If wbCheck = "" ...
ActiveWorkbook.Close SaveChanges:=False End Sub Ø本节内容参考程序文件:Chapter03-2.xlsm 9保存并关闭工作簿Close a Workbook after Saving Sub mynzvba_close_workbook() Dim wbCheck As String wbCheck = Dir(ThisWorkbook.Path & "\myFile.xlsx") If wbCheck = "" Then Workbooks("工作簿1").Close ...
The workbook will close without saving the last changes. Things to Remember TheWorkbook.Closemethod ofVBAuses a total of3parameters. We’ve used only the first one, theSaveChengesparameter. Along with it, it used2more parameters calledFileNameandRouteWorkbook. Download Practice Workbook Download t...
Close a Workbook without Saving Close a Workbook after Saving Related Tutorials You need to use the “Close” method to close an Excel file. With this method, you can specify whether you want to save the changes or not. If you want to save and close a file that has not been saved yet...
wb.Close SaveChanges:=False End If ' Get the next file name fileName = Dir Loop Else MsgBox ...
I am trying to do a macro to do some editing to an words enable file. Done research on how to close the Excel file without saving, which Santosh had successfully help me solve the problem Solution.Tried applying to words There is no error while compling and saving Placed the following cod...
I have the following code that is working but the line .close closes the WB without saving: Option Explicit Public Function updateStatus(fpath As String, fname As String, num As String) Dim wk As String, yr As String Dim owb As Workbook Dim trow As Variant With Application .DisplayAlerts...
Excel Prompts for Saving and Closing a Workbook After making changes to Excel file, if you attempt to close the workbook without saving it first, Excel displays aPromptwindow saying, “Want to save your changes to…”. Similar prompts are displayed when users try to save files in different ...
'Close the Acrobat application. boResult = objAcroApp.Exit Else 'Something went wrong, so close the PDF file and the application. 'Close the PDF file without saving the changes. boResult = objAcroAVDoc.Close(True) 'Close the Acrobat application. ...