January 2017

• Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes] 16

December 2016

• FREE Download : Send Multiple Emails Tool – Ver 4.0 18
• Wish you all a Merry Christmas 2016 0
• Image in Signature not Displayed - Mail Sent by VBA 4
• Calculate distance between two places in Excel [With Fun] 2
• What if you do not have internet ?? 0
• get Data Type of Variable in VBA - VarType() VBA function 0
• VBA to Add Static Google Map in Excel Sheet 1
• Windows FileDialog to Select File or Folder Path in VBA 0

November 2016

• Excel Tool : Folder Structure Creator 0
• How to create folders in windows via Excel VBA 1
• List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD] 3
• Send Image of a Range from Excel embedded in Mail [Inline Image in Mail] 1

October 2016

• [Personal] Wish you a very happy Diwali 0
• [VIDEO] Excel VBA Tip - Hide Horizontal scroll bar in Excel 0
• [VIDEO] Excel Macro Tutorial-Part-2- Your first VBA Program 0
• [VIDEO] Excel Macro Tutorial-Part-1-Introduction to Excel VBA 1
• Button to Zoom in a Graph in Excel - [Method 2] 1
• [Video Tutorial] How to add controls like command button in excel [For Beginners] 1

June 2016

• Button to Zoom in a Graph in Excel - [Method 1] 1

May 2016

• How to Get Excel version using VBA Code 3

April 2016

• Invoice Template [ FREE Download ] 4
• VBA Beginners: How to write macro for a Command Button 0
• Excel Tip: How to refer characters using ASCII Value 0

December 2015

• How to find Visible Range in Excel window on a Screen 2
• Wish you Merry Christmas & happy Holidays 0
• Excel VBA Tips: How to comment or uncomment a Block of Code in VBA 0
• Excel VBA Basics : All about Debugging Excel VBA code 2

July 2015

• Interacting with Powerpoint Slides – Tutorial – Part 2 (Last) 0

December 2014

• Register Yourself for FREE Session on “Basics of Excel VBA” 1

October 2014

• Wishing you and your Family a Very Happy Diwali 0

September 2014

• Interacting with Powerpoint Slides - Tutorial - Part 1 1
• Excel VBA - Few little help in your day-to-day Coding 0

July 2014

• CELLS() and RANGE() - Are they same? Are they Excel VBA Object? 4
• Excel Macro Beginners - What is Range Object in Excel VBA 2
• Different ways of Reading RecordSet Object in Excel Macro 5
• Query Database and Spreading the Records in Excel - VBA Code 8

June 2014

• How to refer Values from a Named Range - Excel VBA 0
• Excel Tip : How to Make an Excel Cell secured for Password 5
• Excel Macro : Excel VBA code to Protect OR UnProtect Sheet 2
• Excel Macro : Excel VBA code to Print the Sheet 12
• VBA String Functions - INSTR() Function 0
• Spreading data across Columns in Excel Without VBA Code 0
• Read and Write Document Properties of an excel Document - VBA 9

May 2014

• Excel VBA - What is SPLIT Function? 5
• Excel OFFSET Function - Excel Tutorial 3
• Excel Trick - Sheet Protection - Protect it and Stay Free 6
• Excel Trick - SMART Method to make White Background 4
• Custom Formula to Reverse a String in Excel 1
• How to create User Defined Function in Excel 1

April 2014

• Excel VBA Tip - Expand / Collapse all the Groups in Excel 6
• Things happening AUTOMATICALLY is WOW… but NOT ALWAYS 0
• FREE Download : Send Multiple Email Tool - Ver 3.0 31
• Spreading an Array values across Rows in Excel - VBA 0
• Spreading an Array values across Columns in Excel - VBA 4

March 2014

• Download Free Add-in - File Manager 4

September 2013

• HP Quality Center - Excel Macro to Import Test Cases from QC 44
• HP Quality Center - Check if Connection to QC is made successfully ? 5
• Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls) 3
• HP Quality Center - Create Folder Structure in Test Lab and Pull test Cases from Test Plan 25
• HP Quality Center - Connect to HP QC using Excel VBA 77
• Email ID Syntax Validation in Excel 1

June 2013

• How to insert a picture in excel using VBA 10
• Few very useful and small macros 0
• Check if file is already open using excel VBA 4
• Assign a Hot Key to a Command Button in Excel 3
• Assign a Shortcut Key using Excel VBA 2
• How to assign a Shortcut key to a Procedure or Subroutine 0

February 2013

• Input Box and “Smart” Input Box 2

December 2012

• Merry Xmas to you All - 2012 0
• Get Special Folder Path using VBA 4
• Sending a HTML Email using Word Email Template and Excel Macros 10

November 2012

• Download : Excel Macro Application to Send Multiple Emails - 2.0 46
• Send Sheet as a PDF attachment in Email 17
• How to Export an Excel Sheet as PDF file 5
• How to display Input message on selecting a cell in Excel 2
• Happy Diwali - 2012 0

October 2012

• Important : Declaring multiple Variables with one Dim Statement 0
• VBA Programming : Decision - Select Case 2
• Implicit and Explicit declaration of variables in VBA 1
• How to insert Outlook Signature in Email by Excel VBA 11

September 2012

• Pivot Table Tutorial : Make Pivot Table in 15 Seconds 0
• What is Pivot Table ? 0

August 2012

• Mail Chart as Image from Outlook - VBA Code 15
• Library not registered - Automation error 2
• How to Send more than one Sheet of the workbook in mail 1
• How to Send ActiveSheet as Attachment in mail 4
• Download Free File Manager - New Version 7

July 2012

• Excel Formula : MATHEMATICAL Formulas 2
• Excel Formula : DATE and TIME Formula 0
• What is Excel Formula ? How to use Excel Formula? 0
• Allow Cell Drag and Drop Option in Excel 2003, 2007 and 2010 27

June 2012

• How to Send Email Automatically from Excel 40
• How to Schedule a Task in Windows 7 4
• Download : Excel Macro Application to Send Multiple Emails 50
• Download Free : GTIN Calculator in Excel 0
• Download Free File Manager in Excel Macro 0
• Excel Tips : Enter Current Date Without Typing in to the Cell 0
• Entering the Current Date into a Cell 0
• Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding) 0
• Excel Macro Tutorial : How to Open Excel Workbook using Excel Macro 1
• How to Declare a Public Variable in VBA 0
• How to get Excel Range in Array 9
• Excel Macro Tutorial : Excel Form 32

April 2012

• VBA Programming : String Manipulation 0
• VBA Programming : If Then Statement 4
• VBA Programming : Variables in VBA 11
• Assigning Macro : How to assign macro to Hyperlink ? 6
• User Defined Function in Excel to Convert Currency to Words 2

March 2012

• Excel Macro Tutorial : How to Use ListBox in Excel 2
• Excel Macro Tutorial : ComboBox in Excel Macro 13

February 2012

• Progress Bar in Excel VBA 39
• Name Range in Excel 1
• How to Export Delimited Text File in Excel 1
• Shortcut Keys in Microsoft Excel 1
• DATEDIF Worksheet Function : Age Calculation 0
• Excel Macro Tutorial : Toggle Button in Excel 0

January 2012

• Difference between Sheets and Worksheets in Excel Macro 1
• How to Send ActiveWorkbook as attachment in Email 5
• How to get Word Count and Letter Count in Excel Formula 1
• Excel UDF: How to Get All words in Reverse Order from a String 0
• Excel UDF: To exctract All Numbers, Special Characters and Alphabets from a String 2
• How to format whole row or a Range by Conditional Formating 1
• Format Alternate Rows using Conditional Formatting 0
• Excel Macro Tutorial : While Loop and Do While Loop in Excel VBA 6
• Excel Macro Tutorial : For Next Loop in Excel Macro 3
• Macro to Copy from Excel in to Word Document 4
• How to Copy content from Word using VBA 1
• How to compare two columns in Excel to find duplicates 15
• How to interact with HTML pages from Excel 25

December 2011

• Strip HTML : How to Remove HTML tags from a String in VBA 15
• References In Excel Formulas - Absolute and Relative 1
• Excel Macro Tutorial : VBA Spin Button 4
• How to send email from Excel Macro from Outlook 16
• How to Send an Email using Excel Macro from Gmail or Yahoo 95
• How to Disable Right Click in Excel Workbook 4
• COUNT and COUNTA Function 0
• How to Extract Email ID from a String in Cell 3
• Auto Open Macro / Auto Run Macro 0
• ADO RecordCount Property - RecordSet Object 0
• How to connect to Access Database - ADO Connection String 13
• Excel Macro Tutorial : How to write Excel Macro - Your First Excel Macro 10
• Excel Macro Tutorial : VBA Control Property 2

November 2011

• How to force proper case in textbox 0
• Textbox first Letter in Caps and Rest other in Lowercase 0
• How can I force input to Uppercase or Lowercase in a Textbox 0
• SQL Connection using Excel Macros 2
• How to Create Drop Down List in Excel 6
• Show all Formulas in an Excel Sheet 0
• File Name Formula 2
• Hide Horizontal or Vertical Scrollbar in Excel Workbook 0
• Conditional Formatting based on Condition in other Cell 0
• How to Edit Existing Conditional Formatting 1
• Conditional Formatting in Excel 3
• VBA: Reverse a string 0
• How to run a .bat file (Batch File) by Excel Macro 4
• Sorting a String stored in a cell of Excel 0
• List All files from Folder and Sub-folders in Excel Workbook 126
• GTIN Calculator in Excel 9
• Oracle Connection String in VBA 49
• Restrict to fixed text or integer length in the given range of cells 0
• Filter by Cell Color in Excel 1
• Sorting using Excel Macro 3
• Delete Sheet In VBA Without Notification 1
• DateAdd() Function 4
• Wait Function 0
• Excel Macro Tutorial : Visual Basic Editor in Excel 1
• Macro Security 0

October 2011

• Different Settings of Controls in Excel Macro 0
• Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel 5
• Excel Macro Tutorial : What is Excel Macro ? 63
• Excel Macro Tutorial : Add Developer Tab in Excel - 2007 and 2010 6
• Add a Sheet using Excel Macros 2
• How to restrict some key or Characters in text box in a Excel Macro 0
• How to display different types of message box in excel macro 1
• How to save and Close an Excel Sheet using Macro 0
• How to delete a selected sheet using Excel Macro 0
• Update cell value after change is made in different cell or Cell Range 0
• How to disable/Invisible Horizontal/Vertical Scroll Bar 1