Vba Thisworkbooksave Doesnt Work. Save" once all the codes and module is deleted. In Microsoft Office Excel, Microsoft Visual Basic for Application (VBA) macro code that is contained "behind" a worksheet or workbook may not work correctly.
Here is the VBA code that uses ThisWorkbook. SaveCopyAs won't work if the main macros is running and calls ThisWorkbook. So, now you need to create a new workbook and save workbook using VBA Macro. this is good.
If I immediately close down the file without doing anything, ThisWorkbook.
With VBA, you can do a lot of stuff with a workbook object - such as open a specific workbook, save and close workbooks, create new workbooks, change In this tutorial, I will cover the how to work with workbooks in Excel using VBA.
The reference word "ThisWorkbook" is more reliable than the Workbooks object qualifier. Copy Set wb = ActiveWorkbook With wb. You can select code in your VBA window, press Tab, then copy and paste into your post or comment.