VBA Macros

• Excel VBA Objects,Methods and Properties
• Macro to Add, Open, Save A Workbook
• Macro to Create a Back up for Active Workbook with Current Date in Same Location
• Macro to Save or Export Active Sheet Data into a New Workbook
• Excel VBA Auto Popup and Self Closing Message Box
• Macro to Insert Desired No.of Columns
• Macro to Insert Desired No.of Rows
• Macro to Insert Desired No.of Cells
• Excel VBA Macro To Format Border Styles , Font Styles
• Excel VBA Macro for Data AlignMent
• Macro to Apply Border Around or Outsider Border to the Selection
• Macro to Create User Defined Functions in Excel
• Macro to Store Values into an Array and Retrieve the Values from an Array
• Excel VBA Macro To Auto Fill Default , Auto Fill Series
• Macro To Delete Filtered Rows from a Range in a Sheet
• How to Select First Visible Cell in a Column of a Filtered Range
• How to Select all Visible Cells in a Column of Filtered Range and Fill with a Desired Value
• How to add an Excel Range to an ActiveX ComboBox List on DropButtonClick
• What is the difference between Range.Resize and Range.Offset in VBA
• How to get filtered Pivot Data from an Input File in to a Target Template File using Excel VBA Macro
• How to Filter Numbers Begins with In Excel and Copy the Filtered Range to a New Sheet
• How to Apply Pivot Filter from a Range of Values in Excel
• How to List the Information of all the Pivots of a Workbook into to a New Sheet
• Excel VBA Pivot Table Standard Operations
• How to Know the Pivot Field Orientation in Excel Pivot Table with VBA
• VBA Macro to Select the Dynamic Actual UsedRange in Excel
• How to Find Current Region, Used Range, Last Row and Last Column in Excel with VBA Macro
• Workbook Event BeforeClose to Prevent the Closing of a Workbook when Specific Cell Value is Blank
• Work Sheet Change Event to Save a Workbook on Changing a Cell Value in a Specified Range
• Workbook Event BeforeSave to Prompts the User for his Response to really Save the Workbook or Not
• WorkSheet Event BeforeDoubleClick for Zooming in and Out of a Worksheet with Double Click
• Worksheet_Activate Event to Hide the Blank Data Rows with VBA Macro
• VBA Application.Onkey to Disable Cut,Copy,Paste and Delete Keys
• Macro to Auto Fill a Specified Number of Times & Copy the Same
• Excel VBA Macro to Sort the Data
• Macro to Create List Names or Range Names with Column Headings
• How to Create Table of Contents and Index for a Report in Excel
• Macro to Add Column Headings as Worksheets
• Macro to Trim Data and Delete Duplicate Records
• Macro to Delete Selected Cells , Rows, Columns In a Active Work Sheet
• Macro to Clear Contents,Formats of a Active Work Sheet
• Macro to Change Text Case
• How to Convert Numbers Stored in Text Format to Numbers
• Macro to Know Number of Days, Weeks, Months, Quarters Between Two Dates
• Macro to know Number and Name of Day, Week, Month, Quarter in a given Date
• How to use Select CASE Statement in VBA
• How to use Excel VBA Instr Function
• How to use VBA Split Function
• Dynamic Multi Purpose Macro
• Macro to Remove Duplicates in Multiple Columns
• Macro to Sort Pivot Table Row Labels, Column Field Labels and Data Values
• Macro to Set the Pivot Table Grand Totals on Rows and Columns
• Macro to Export or Save Each Sheet as Tab Delimited Text File
• VBA Macro to Import the Data from Text(.txt) file to Excel(.xls) and Save in Destination Folders
• How to Import Data from a Text File using Excel VBA Macro
• How to Import and Export Data between This Workbook and Target Workbook
• Consolidate Multiple Columns Data In a Dynamic Column and Remove Duplicates
• Macro To Consolidate or Merge All Sheets Data Into One Sheet
• Macro To Merge Multiple Workbooks into One Workbook
• Excel VBA Macro to Save Each Sheet of a Work Book as PDF File
• Macro to Know First Occurrence of a String Based On Multiple Criteria
• Excel VBA Macro to Convert Excel Formulas to Values In Each Sheet
• Excel VBA Macro to Sum The Individual Digits of Number
• Excel VBA Macro to Convert Cell Values To Hyper Links
• Macro to Grouping Records of the Same Date in Main Sheet
• Macro to Find Difference of Maximum and Minimum Dates using Array
• Excel VBA Macro To Create a Daily Task Workbooks For Current Month
• Excel VBA Macro To Create a Monthly Task Workbook with All Day Sheets
• Excel VBA Auto Popup and Self Closing Message Box
• Excel VBA Macro to Copy Daily Task Files to Respective Day Folder
• Macro to Copy different Types .txt,.xlsx,.docx,.pptx of Files to Respective Type Folder
• Macro to Copy the Files from Different Locations or Paths to Multiple Destinations
• Macro to Display the Latest Modified File Name in a Specified Path
• Macro to Check and Count the No.Of Files and Subfolders exist in a Folder
• Macro to Open a Special Folder
• Macro to Copy a File from One Path to another Path
• Macro to Rename and Move a File to another Location
• Macro to Remove All Excel Files from a Desired Directory or Folder
• Macro to Delete whole Folder with All Files
• Macro to Delete all Files and Sub Folders In a Folder
• Macro to Delete a specific File from a Folder
• Macro to Open Dialog Box To Select and Merge Multiple Workbooks into Main Workbook
• Excel VBA Macro To Consolidate All Sheets In One Sheet
• Macro to Consolidate desired Sheets In to one Sheet
• Excel VBA Macro To Segregate Data by Region and Export to New Work Books
• Excel VBA Macro to Segregate Data from One Sheet To Many
• Excel Macro to Show Combined Cell Contents In Comment Box
• Macro to know First Occurrence of a String Based on Multiple Criteria
• VBA Macro to extract Strings exactly Match with desired String in Excel
• VBA Macro to extract Strings Start with a desired Sub String
• VBA Macro to extract Strings End with a desired Sub String
• Macro to Update Main Workbook data Sheets with Respective Sheets Data of Sub Workbook
• Macro to Create a Folder By Current Date and Time ,Export Active Sheet Data to a New Workbook by Active Sheet Name

• How to Send Active Sheet as an Outlook Email Attachment with VBA
• How to Send a Range from an Active Sheet in an Outlook Email Body from Active Workbook with VBA
• How to Send Active Sheet as a PDF Attachment Via Through Outlook Email

• Macro to change Pivot Chart Slicer Filter Item dynamically and and Print the Chart of each Slicer Item on Power Point Slides
• Macro to Generate PowerPoint Slides for each Chart in Active Sheet
• Macro to Generate Power Point Presentation Slides for each Chart with Titles and Notes in Active Sheet
• Macro to Copy and Print each Named Range on a Power Point Presentation Slides

• MS Access Data Types
• How to Run an Access Macro from Excel VBA Macro
• Macro to Delete all Records from a MS Access Table
• Macro to Import or Copy All Data from a MS Access Database Table into Excel Sheet
• Macro to Import or Copy All Data from Specific Fields from a MS Access Table into Excel
• Macro to Import or Copy All Data from a MS Access Database Table in to Excel Sheet
• Excel VBA Macro to Delete all Records from a MS Access Table
• Error '2342' Can't run a SQL Query - "A RunSQL action requires an argument consisting of an SQL Statement"
• How to Delete all Records from a MS Access Table with Excel VBA Macro
• How to Run VBA Macro Code with a Microsoft Access Macro
• How to Export MS Access Queries Results into Excel
• How to Export All MS Access Tables Data to Excel
• Access VBA Macro to Copy Excel Data Range to Access Database Table
• How to Copy Data from Excel Active Sheet into MS Access Table
• How to Import or Copy All Data from a MS Access Database Table in to Excel Sheet
• Excel VBA Macro to Import or Copy All Data with SQL Query from from Specific Fields of a MS Access Table into Excel Sheet
• Access VBA ADODB CopyFromRecordset Method to Copy All Fields Data from Access Table to Excel
• Access VBA DAO CopyFromRecordset Method to Copy All Fields Data from Access Table to Excel
• Access VBA ADODB CopyFromRecordset Method to Copy Selected Fields Data from Access Table to Excel
• Access VBA DAO CopyFromRecordset Method to Copy Selected Fields Data from Access Table to Excel
• ADODB Recordset Metod to Export data from Excel Worksheet to an Access Database Table

Note :
For more Tutorials please search and refer in blog posts.