excel-macro.tutorialhorizon.comTutorial Horizon - Excel Macro Tutorials

Skip to content Excel-Macro Search for: Home Cells Ranges Offset 3D-Ranges Activate ActiveCell Current Region Select Functions Array Functions Date Time Math Functions String User Defined Function Tools and Games Automate Excel WorkBook Microsoft Outlook Microsoft Word Internet Explorer XML FireFox FSO Operations Copy-Paste Opearions Clipboard Operations MISC Macros Reference Libraries User Forms WorkBook and WorkSheets Other Sites JavaScript Algorithms Android Git Excel-Macro @TutorialHorizon Home Cells Ranges Offset 3D-Ranges Activate ActiveCell Current Region Select Functions Array Functions Date Time Math Functions String User Defined Function Tools and Games Automate Excel WorkBook Microsoft Outlook Microsoft Word Internet Explorer XML FireFox FSO Operations Copy-Paste Opearions Clipboard Operations MISC Macros Reference Libraries User Forms WorkBook and WorkSheets Other Sites JavaScript Algorithms Android Git 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: Reference Libraries in Excel WorkBook. User Forms User Define Functions Share this: Facebook Email LinkedIn Twitter Tumblr Like this: Like Loading... Follow: Search for: Recent Posts VBA-Excel: Read XML by Looping through Nodes VBA-Excel: Create worksheets with Names in Specific Format/Pattern. VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet VBA-Excel: Create or Add Worksheets at the Run time. VBA-Excel: Change Font, Color, Weight of Table Data in the Word document VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Fi...