![]() Save Excel workbook as Excel Macro FREE Workbook without confirmation Popup ![]() To ignore this popup in Excel VBA code, you simply use Application.DisplayAlerts to false before executing the above statement. This can be annoying in an automated process. While executing the above, VBA statement, you will receive the same confirmation popup as shown above – which you get while saving your. ThisWorkbook.SaveAs Filename:="C:\.\abc.xlsx", FileFormat:=xlOpenXMLWorkbook Now as you have seen how to achieve this manually, I will show you how you can achieve this by using Excel VBA.įollowing VBA statement will be able to save your Workbook with Excel Workbook as a Workbook without any Excel VBA code in it. VBA Method: Save Workbook without Excel Macro using Excel VBA
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |