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
  •  VBA-Excel: Read Data from XML File
  •  VBA-Excel: Create and Save the Word document
  •  Excel-VBA : Range - Lock/Unlock Specific Cells
  •  VBA-Excel: Open an Existing Word Document
  •  VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook)
  •  VBA-Excel: Reference Libraries in Excel WorkBook.
  •  Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
  •  VBA-Excel: Writing Text to Word document
  •  VBA-Excel: Read XML by Looping through Nodes
  •  VBA-Excel: Copy/Paste data - Copy the Entire row data and paste it to another row
Subscribe to Blog via Email
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
 Join 657 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
 © 2021 Excel-Macro • Powered by GeneratePress