All Articles


Automate Microsoft Word using Excel-VBA

1Open a MS Word Document using Excel File using Explorer Window.
2Merger — Merge or Combine Many Word Documents Into One
3Format the Existing Table in a Word document
4Add Table and fill data to the Word document
5Open word document using GetObject()
6Enumerate all the opened word document
7Get the Instance of already opened word document
8Working with Bookmarks– Insert text After Bookmark
9Working with Bookmarks– Insert text before Bookmark
10Find a word in a specific paragraph and change its formatting
11Format already written text in a word document – Format Paragraphs
12Format already written text in a word document – Format All Content
13Open and Print the Word Document
14Add/Insert multiple Images/Pictures from a folder in Word Document
15Add/Insert a Image/Picture in Word Document
16Appending Text to an Existing Word Document — at the End
17Appending Text to Existing Word Document — at Beginning
18Edit And Save an Existing Word Document
19Writing Text to Word document
20Open an Existing Word Document
21Create a new Word Document


Automate Microsoft Outlook using Excel-VBA

1Send a Simple Mail From MS Outlook Using Excel
2Send a Mail using Predefined Template From MS Outlook Using Excel
3Send a Excel Workbook as Attachment in Mail From MS Outlook Using Excel
4Send Mail with Embedded Image in message body From MS Outlook using Excel.
5Send Unique Images Embedded to Mail Body, With Every Mail From MS Outlook using Excel.
6Download all the Attachments from All the Mails of Specific Subject in Microsoft Outlook .
7Send Mail With Multiple Different Attachments From MS Outlook using Excel.
8Send Mail With Link to a Workbook, From MS Outlook using Excel.


Automate Microsoft Excel using VBA

1Open a Excel File using Another Excel File using Browse Option.
2Insert Multiple Images from a Folder to Excel Cells
3Change Passwords for all the WorkSheets in one shot
4Convert Numbers (Dollars, Euros) into Words or Text — Till Trillions
5Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
6User Forms
7Application.Wait OR Wait Method
8Add/Insert multiple objects from a folder in an Excel Document.
9Fill Excel Range Values in a 2D Array
10Convert Numbers (Rupees) into Words OR Text — Updated Till 1000000 Crore
11Create Dynamic or Run-time WorkSheets using Macro.
12 WorkBook.Save Method
13Open a Excel WorkBook
14Create a WorkBook at Runtime.
15Prevent Changing the WorkSheet Name
16Prevent Adding New Worksheet
17Change Passwords for all the WorkSheets in one shot
18CurrentRegion
193D-Ranges – FillAcrossSheets Method
20Active Cell
21Select and Activate Cells — Select
22Looping Through a Range of Cells
23Refer to Multiple Ranges : Union Method
24Refer to Cells by Using Shortcut Notation
25Refer Range by using A1 Notations
26Clear data from Excel Sheet(WorkSheet)
27UsedRange
28Get the names of all WorkSheets in a Excel (WorkBook)
29Delete Blank Rows from Excel Work Sheet
30Cells, Ranges and Offset : Offset
31Cells, Ranges and Offset : Range
32Cells, Ranges and Offset : Cells
33Message Boxes in VBA Excel (Msgbox)
34WorkBooks and WorkSheets
35Add Tools to Quick Access Tool Bar(Excel Top Bar)
36Visual Basic Editor
37VBA Codes — Record Macro
38How to Enable Macro in Excel
39Getting Started with Excel Macro


Automate XML document using VBA

1Update XML File
2Read Data from XML File


Tools And Games

1Change Passwords for all the WorkSheets in one shot
2Convert Numbers (Dollars, Euros) into Words or Text — Till Trillions
3AttachmentFetcher — Download all the Attachments from All the Mails of Specific Subject in Microsoft Outlook .
4Merger — Merge or Combine Many Word Documents Into One
5Consolidator – Merge or Combine Multiple Excel Files Into One
6Convert Numbers (Rupees) into Words OR Text — Updated Till 1000000 Crore
7SUDOKU Solver
8Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order


Copy-paste Opearions

1Copy the Entire data from one sheet to another
2Copy the Entire row data and paste it to another row
3Copy the range of data and paste it to another range
4Copy the data from a call and paste it to another cell


Clipboard Operations

1Storing multiple data In the Windows Clipboard
2Get Text from the Windows Clipboard
3Putting Text In The Windows Clipboard


Working With Internet Explorer

1Perform Google Search on Internet Explorer using Microsoft Excel
2Login To Already Opened GMAIL In An Internet Explorer (IE)
3Get ALL The Opened Internet Explorer (IE) using Microsoft Excel
4Launch Mozilla Firefox using Microsoft Excel.
5Automate Internet Explorer (IE) using Microsoft Excel – Login into Gmail.
6Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel.
7Launch Internet Explorer (IE) using Microsoft Excel.
8Working with Internet Explorer


File System Object

1GetExtensionName Method2GetParentFolderName Method3DriveExists Method
4GetDriveName Method5MoveFile Method6GetFileVersion Method
7GetFile Method8FileExists Method9CopyFile Method
10DeleteFile Method11GetFolder Method12FolderExists Method
13CopyFolder Method14MoveFolder Method15DeleteFolder Method
16CreateFolder Method17OpenTextFile Method18CreateTextFile Method
19GetAbsolutePathName Method


Array And It Functions

1One Dimen­sion, Sta­tic Array2One Dimen­sion, Dynamic Array
3Two Dimen­sional, Sta­tic Array4Two Dimen­sion, Dynamic Array
5Multi Dimen­sional Array6Fill Excel Range Val­ues in a 2D Array
7Array Functions – Filter()8Array Functions – Join() – Converts Array to String
9Array Functions – IsArray() 10Array Functions – LBound and UBound()
11Create Array using Array() Function12Array Functions – Split()


String Functions

1INSTR() 2Instr­REV()3LCase()
4UCase()5Left()6Right()
7LTrim()8Trim()9Mid()
10RTrim()11Replace()12Space()
13Len()14Str­Comp()15String()


Math Functions

1FORMAT()2FIX()3INT()
4VAL()4SGN/SIGN()6ROUND()
7RND()6LOG()9EXP()
10TAN()8Sin()12Cos()
13Atn()10Abs()


Date-Time Functions

1Timer()2TimeValue()3TimeSerial()
4WeekDay() 5WeekDayName()6Month()
7Year()8MonthName()9Hour()
10Minute()11 Second()12FormatDateTime()
13Day()14DateValue()15DateSerial()
16DatePart()17DateDiff()18DateAdd()
19IsDate()20CDate()21Date()
22Now()23Time()


MISC:

Show Buttons
Hide Buttons
%d bloggers like this: