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

All Articles


Automate Microsoft Word using Excel-VBA

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


Automate Microsoft Outlook using Excel-VBA

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


Automate Microsoft Excel using VBA

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


Automate XML document using VBA

1 Update XML File
2 Read Data from XML File


Tools And Games

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


Copy-paste Opearions

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


Clipboard Operations

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


Working With Internet Explorer

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


File System Object

1 GetExtensionName Method 2 GetParentFolderName Method 3 DriveExists Method
4 GetDriveName Method 5 MoveFile Method 6 GetFileVersion Method
7 GetFile Method 8 FileExists Method 9 CopyFile Method
10 DeleteFile Method 11 GetFolder Method 12 FolderExists Method
13 CopyFolder Method 14 MoveFolder Method 15 DeleteFolder Method
16 CreateFolder Method 17 OpenTextFile Method 18 CreateTextFile Method
19 GetAbsolutePathName 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 Functions – Filter() 8 Array Functions – Join() – Converts Array to String
9 Array Functions – IsArray() 10 Array Functions – LBound and UBound()
11 Create Array using Array() Function 12 Array Functions – Split()


String Functions

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 Functions

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 Functions

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


MISC:

%d bloggers like this: