Ms-Excel is still one of the most popular applications used all over the world by enterprises, big and small. Using Excel, you can now maintain complex data structures, create graphs and more. You can ...
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 ...
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 ...
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 ...
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 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 ...
You can insert different kinds of shapes in your Excel worksheet, like a circle or a rectangle etc. These shapes can be used for various purposes and you can easily change its properties like ...
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 ...
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 use WinForms DataGridView control for doing CRUD operations. Your data source can be anything like an SQL Server database, JSON or Ms-Excel. Here in this post I am sharing a small program in ...