Skip to content

Excel-Macro

@TutorialHorizon

  • Home
  • Cells Ranges Offset
    • 3D-Ranges
    • Activate
    • ActiveCell
    • Current Region
    • Select
  • Functions
    • Array Functions
    • Date Time
    • Math Functions
    • String
    • User Defined Function
  • Tools and Games
  • Automate
    • Excel WorkBook
    • Microsoft Outlook
    • Microsoft Word
    • Internet Explorer
    • XML
    • FireFox
  • FSO
  • Operations
    • Copy-Paste Opearions
    • Clipboard Operations
  • MISC
    • Macros
    • Reference Libraries
    • User Forms
    • WorkBook and WorkSheets

VBA-Excel: WorkBook.Save Method

January 30, 2015May 17, 2013 by Sumit Jain

Save() method is used to save the changes in the workbook.

Save the active WorkBook.

  •   ActiveWorkBook.Save

 

Function FnSaveAllOpenedWorkBooks

    For Each objWB in Application.WorkBooks

        objWB.Save

    Next

End Function

 

 Categories Excel WorkBook, Excel-Macro-VBA Leave a comment
 Post navigation
VBA-Excel: Open a Excel WorkBook
VBA-Excel : Strings Functions – InstrRev
  
Most Visited
  •  Excel-VBA : Range - Lock/Unlock Specific Cells
  •  VBA-Excel: Create and Save the Word document
  •  VBA-Excel: Read Data from XML File
  •  Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
  •  VBA-Excel: Reference Libraries in Excel WorkBook.
  •  VBA-Excel: Open an Existing Word Document
  •  VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook)
  •  VBA-Excel: Read XML by Looping through Nodes
  •  VBA-Excel: Add Table and fill data to the Word document
  •  Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
Subscribe to Blog via Email
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
 Join 621 other subscribers
  
     
Recent Posts
  •  VBA-Excel: Read XML by Looping through Nodes
  •  VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
  •  VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
  •  VBA-Excel: Create or Add Worksheets at the Run time.
  •  VBA-Excel: Change Font, Color, Weight of Table Data in the Word document
  •  VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
  •  Send Mail With Link to a Workbook, From MS Outlook using Excel.
  •  Send Mail With Multiple Different Attachments From MS Outlook using Excel.
  •  Excel-VBA : Open a MS Word Document using Excel File using Explorer Window.
  •  Excel-VBA : Send Unique Images Embedded to Mail Body, With Every Mail From MS Outlook using Excel.
  •  Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
  •  Excel-VBA : Send a Excel Workbook as Attachment in Mail From MS Outlook Using Excel
  •  Excel-VBA : Open a Excel File using Another Excel File using Browse Option.
  •  Excel-VBA : Send a Mail using Predefined Template From MS Outlook Using Excel
  •  Excel-VBA : Send a Simple Mail From MS Outlook Using Excel
 © 2020 Excel-Macro • Powered by GeneratePress