VBA-Excel: Read XML by Looping through Nodes
In our earlier post we have seen How to read data from XML file. In this post we will extend it further and loop through xml and print all the child nodes value under...
Author: SJ
VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
Download Link:Worksheets Many times we find ourselves in a situation where we want to allow users to add the new worksheets and the sheet name must follow some specific format or pattern. Recently...
VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
Download Link: Multi Sheets Objective: This tool is very useful. Many times we encounter a situation where we need to maintain a report on the daily basis (For weekdays). We manually create a...
VBA-Excel: Create or Add Worksheets at the Run time.
Objective: This article will teach you “how to add worksheets in excel workbook at the run time”. Important Command: Workbook. Worksheets.Add().Name = “NameYourSheet” Complete Code: Sub Sumit() Dim mainWorkBook As Workbook Set mainWorkBook =...
VBA-Excel: Change Font, Color, Weight of Table Data in the Word document
To Change Font, Color, Weight of Table Data in the Word document using Microsoft Excel, you need to follow the steps below (First we will create a table and while filling the data we change...
VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
Download Link: MergeExcel This is the extension of my earlier article “Consolidator“. In this article we will modify it further. Suppose we have a scenario where we have multiple excel files with same columns...
Send Mail With Link to a Workbook, From MS Outlook using Excel.
In earlier post you have learned Send Mail with Embedded Image in message body From MS Outlook. In this article we will learn about how to Send Mail With a link in a Message...
Send Mail With Multiple Different Attachments From MS Outlook using Excel.
In earlier post you have learned how to send Excel Workbook as attachment with email from MS Outlook using Excel. In this article we will learn about how to Send Mail With Multiple Different...
Excel-VBA : Open a MS Word Document using Excel File using Explorer Window.
This tutorial will teach you how to Open a MS Word Document using Excel File using Explorer Window. We will be using Application.GetOpenFile() function to accomplish this. NOTE: You can define any type file...
Excel-VBA : Send Unique Images Embedded to Mail Body, With Every Mail From MS Outlook using Excel.
Many a times you need a scenario when you want to send a mail on the daily basis and every new mail contain new image embedded to the mail body, say for example you...
Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
In previous articles you have learned about Send a Simple Mail From MS Outlook Using Excel and how to send Attachment With the Mail MS Outlook Using Excel. ( I recommend you first read...
Excel-VBA : Send a Excel Workbook as Attachment in Mail From MS Outlook Using Excel
In out earlier post we have seen, How to send a simple text mail using MS Excel. In this tutorial we will learn How to send the entire Excel Workbook as attachment along with...
Excel-VBA : Open a Excel File using Another Excel File using Browse Option.
This tutorial will teach you how to Open a Excel File using Another Excel File using Browse Option. We will be using Application.GetOpenFile() function to accomplish this. NOTE: You can define any type file...
Excel-VBA : Send a Mail using Predefined Template From MS Outlook Using Excel
In our earlier tutorial we have seen how to send a simple text mail using MS Outlook but how about when you want to send a proper composed mail, means your will compose the...
Excel-VBA : Send a Simple Mail From MS Outlook Using Excel
This tutorial will teach you about how to send a simple text mail from Microsoft Outlook using excel-macro. Create object of Outlook Application. Create a Mail Item. Compose and Send mail using mail Item....
VBA-Excel: Update XML File
In our earlier post we have seen how to Read Data from XML File using in Microsoft Excel. In this tutorial will teach you about how to update an XML file using Microsoft Excel....
VBA-Excel: Read Data from XML File
To Read Data from XML File using in Microsoft Excel, you need to follow the steps below: Create the object of “Microsoft XML Parser” ) (Microsoft.XMLDOM is the COM object of Microsoft XML Parser)...
Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
Say you have many images in a folder and you want to insert all these images in your excel work book, one image in one cell. You can do it manually, insert and resize...
VBA-Excel: Read Excel WorkBook as DataBase using ODBC Source
You can read an Excel WorkBook as a complete DataBase, means an Excel file can act as Database. You can make range of Rows and Columns as the Tables of your Database which means...
VBA-Excel: Make Excel File as ODBC Source(Database) using Microsoft Excel Driver
To use your Excel file as Database for your project, First you might need to make your excel file as ODBC source using Microsoft Excel Driver. In order to make your excel file ODBC...