Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

All Articles


Auto­mate Microsoft Word using Excel-VBA

1 Open a MS Word Doc­u­ment using Excel File using Explorer Window.
2 Merger — Merge or Com­bine Many Word Doc­u­ments Into One
3 For­mat the Exist­ing Table in a Word document
4 Add Table and fill data to the Word document
5 Open word doc­u­ment using GetObject()
6 Enu­mer­ate all the opened word document
7 Get the Instance of already opened word document
8 Work­ing with Book­marks– Insert text After Bookmark
9 Work­ing with Book­marks– Insert text before Bookmark
10 Find a word in a spe­cific para­graph and change its formatting
11 For­mat already writ­ten text in a word doc­u­ment – For­mat Paragraphs
12 For­mat already writ­ten text in a word doc­u­ment – For­mat All Content
13 Open and Print the Word Document
14 Add/Insert mul­ti­ple Images/Pictures from a folder in Word Document
15 Add/Insert a Image/Picture in Word Document
16 Append­ing Text to an Exist­ing Word Doc­u­ment — at the End
17 Append­ing Text to Exist­ing Word Doc­u­ment — at Beginning
18 Edit And Save an Exist­ing Word Document
19 Writ­ing Text to Word document
20 Open an Exist­ing Word Document
21 Cre­ate a new Word Document


Auto­mate Microsoft Out­look using Excel-VBA

1 Send a Sim­ple Mail From MS Out­look Using Excel
2 Send a Mail using Pre­de­fined Tem­plate From MS Out­look Using Excel
3 Send a Excel Work­book as Attach­ment in Mail From MS Out­look Using Excel
4 Send Mail with Embed­ded Image in mes­sage body From MS Out­look using Excel.
5 Send Unique Images Embed­ded to Mail Body, With Every Mail From MS Out­look using Excel.
6 Down­load all the Attach­ments from All the Mails of Spe­cific Sub­ject in Microsoft Outlook .
7 Send Mail With Mul­ti­ple Dif­fer­ent Attach­ments From MS Out­look using Excel.
8 Send Mail With Link to a Work­book, From MS Out­look using Excel.


Auto­mate Microsoft Excel using VBA

1 Open a Excel File using Another Excel File using Browse Option.
2 Insert Mul­ti­ple Images from a Folder to Excel Cells
3 Change Pass­words for all the Work­Sheets in one shot
4 Con­vert Num­bers (Dol­lars, Euros) into Words or Text — Till Trillions
5 Get all the Week­Days or Work­ing days in Spec­i­fied Date Range, (exclud­ing Sat­u­days and Sundays)
6 User Forms
7 Application.Wait OR Wait Method
8 Add/Insert mul­ti­ple objects from a folder in an Excel Document.
9 Fill Excel Range Val­ues in a 2D Array
10 Con­vert Num­bers (Rupees) into Words OR Text — Updated Till 1000000 Crore
11 Cre­ate Dynamic or Run-time Work­Sheets using Macro.
12 WorkBook.Save Method
13 Open a Excel WorkBook
14 Cre­ate a Work­Book at Runtime.
15 Pre­vent Chang­ing the Work­Sheet Name
16 Pre­vent Adding New Worksheet
17 Change Pass­words for all the Work­Sheets in one shot
18 Cur­ren­tRe­gion
19 3D-Ranges – Fil­lAcrossSheets Method
20 Active Cell
21 Select and Acti­vate Cells — Select
22 Loop­ing Through a Range of Cells
23 Refer to Mul­ti­ple Ranges : Union Method
24 Refer to Cells by Using Short­cut Notation
25 Refer Range by using A1 Notations
26 Clear data from Excel Sheet(WorkSheet)
27 Use­dRange
28 Get the names of all Work­Sheets in a Excel (WorkBook)
29 Delete Blank Rows from Excel Work Sheet
30 Cells, Ranges and Off­set : Offset
31 Cells, Ranges and Off­set : Range
32 Cells, Ranges and Off­set : Cells
33 Mes­sage Boxes in VBA Excel (Msgbox)
34 Work­Books and WorkSheets
35 Add Tools to Quick Access Tool Bar(Excel Top Bar)
36 Visual Basic Editor
37 VBA Codes — Record Macro
38 How to Enable Macro in Excel
39 Get­ting Started with Excel Macro


Auto­mate XML doc­u­ment using VBA

1 Update XML File
2 Read Data from XML File


Tools And Games

1 Change Pass­words for all the Work­Sheets in one shot
2 Con­vert Num­bers (Dol­lars, Euros) into Words or Text — Till Trillions
3 Attach­ment­Fetcher — Down­load all the Attach­ments from All the Mails of Spe­cific Sub­ject in Microsoft Outlook .
4 Merger — Merge or Com­bine Many Word Doc­u­ments Into One
5 Con­sol­ida­tor – Merge or Com­bine Mul­ti­ple Excel Files Into One
6 Con­vert Num­bers (Rupees) into Words OR Text — Updated Till 1000000 Crore
7 SUDOKU Solver
8 Mod­i­fied Con­sol­ida­tor – Merge or Com­bine Mul­ti­ple Excel Files Into One Where Columns Are Not In Order


Copy-paste Opear­i­ons

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


Clip­board Operations

1 Stor­ing mul­ti­ple data In the Win­dows Clipboard
2 Get Text from the Win­dows Clipboard
3 Putting Text In The Win­dows Clipboard


Work­ing With Inter­net Explorer

1 Per­form Google Search on Inter­net Explorer using Microsoft Excel
2 Login To Already Opened GMAIL In An Inter­net Explorer (IE)
3 Get ALL The Opened Inter­net Explorer (IE) using Microsoft Excel
4 Launch Mozilla Fire­fox using Microsoft Excel.
5 Auto­mate Inter­net Explorer (IE) using Microsoft Excel – Login into Gmail.
6 Max­i­mize, Min­i­mize and Restore Inter­net Explorer (IE) using Microsoft Excel.
7 Launch Inter­net Explorer (IE) using Microsoft Excel.
8 Work­ing with Inter­net Explorer


File Sys­tem Object

1 GetEx­ten­sion­Name Method 2 Get­Par­ent­Fold­er­Name Method 3 Dri­ve­Ex­ists Method
4 Get­Drive­Name Method 5 Move­File Method 6 Get­FileVer­sion Method
7 Get­File Method 8 File­Ex­ists Method 9 Copy­File Method
10 Delete­File Method 11 Get­Folder Method 12 FolderEx­ists Method
13 Copy­Folder Method 14 Move­Folder Method 15 Delete­Folder Method
16 Cre­ate­Folder Method 17 Open­TextFile Method 18 Cre­ate­TextFile Method
19 GetAb­solutePath­Name Method


Array And It Functions

1 One Dimen­sion, Sta­tic Array 2 One Dimen­sion, Dynamic Array
3 Two Dimen­sional, Sta­tic Array 4 Two Dimen­sion, Dynamic Array
5 Multi Dimen­sional Array 6 Fill Excel Range Val­ues in a 2D Array
7 Array Func­tions – Filter() 8 Array Func­tions – Join() – Con­verts Array to String
9 Array Func­tions – IsArray() 10 Array Func­tions – LBound and UBound()
11 Cre­ate Array using Array() Function 12 Array Func­tions – Split()


String Func­tions

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


Math Func­tions

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


Date-Time Func­tions

1 Timer() 2 TimeValue() 3 Time­Se­r­ial()
4 Week­Day() 5 Week­Day­Name() 6 Month()
7 Year() 8 Mon­th­Name() 9 Hour()
10 Minute() 11 Second() 12 For­mat­Date­Time()
13 Day() 14 Dat­e­Value() 15 Date­Se­r­ial()
16 DatePart() 17 Date­D­iff() 18 DateAdd()
19 IsDate() 20 CDate() 21 Date()
22 Now() 23 Time()


MISC:

%d bloggers like this: