A spreadsheet application, designed by Microsoft, Ms-Excel is one of the most popular applications with features like pivot tables, graph, and calculations. It also supports a macro programming language called VBA (Visual Basic for Applications).
You can easily modify data in an Excel file from your Windows Forms, popularly known as WinForms. In fact, you can do many things like read, edit and add data to your Excel file from WinForms. Here ...
You must have read my previous article on how to send emails from Excel using VBA macro and Outlook. Now, here in this post I am sharing an example on how to Parse or Extract Outlook emails and show ...
You can open a new word file or document from Excel using VBA. Here in this post I’ll show you an example on how to open a word file from Excel using a Macro. I’ll also show you how to copy Excel data ...
There are different ways to calculate a person’s age in Excel using different types of data. In most cases you will be given a Date from which you’ll need to get or calculate the age. Here in this ...
The Replace function in Excel is an inbuilt function or a pre-defined function, which you can use in your Macro to replace a set of characters in a string with another set of characters. You can ...
You know there are two ways to create Pie charts in Excel. One, create a Pie chart on your own using the tools available or you can use VBA to create Pie charts automatically with the click of a ...
A chart shows data in a graphical format. A Pie chart is a circular chart where it divides the data into slices. Each slice represents a part of the data. Here in this post I’ll show you how to create ...
I have previously shared a post with an example on how to read data from a closed workbook without opening it. I am extending that example, and here in this post I’ll show you how to read multiple ...
In Excel, you can name a cell or a range of cells. Giving a meaningful name to a cell or a range helps understand the data or the set of data it holds. However, named cells have other useful benefits ...
If you are still actively investing in the stock market and use Ms-Excel, then here’s an example on how to get current stock quotes, every few seconds, in your Excel file from a Web page using VBA ...
