Well, you can send emails from Excel using Outlook and a simple Macro. No worries if you dont have access to Outlook or for some reason dont want to use Outlook from Excel. You can still send ...
Let us assume, I have a list of values (numbers or alphabets) in one column and each value has 6 digits. I want to mask the first 3 digits with * (asterix) and show the last 3 digits only ...
In this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table. ...
In this tutorial I will show you how to import or extract Outlook emails into a Word document using VBA. Importing emails from Outlook into Word (or Excel) can help you analyze the data ...
Let us assume I have an Excel file in a folder and I want to copy data as it is to another file (a master file) using VBA. When I am saying as it is I mean the macro should copy data from sheet to ...
In this post I’ll show you how split text string from one cell to multiple cells. I’ve shared 2 different methods: using a new function called TEXTSPLIT and another using a macro in VBA. In-addition ...
Here in this post, I will show you how to create a simple progress bar in Excel using UserForm and VBA ...
Sharing a simple formula in Excel showing how to add days number in sequence quickly. The formula uses the SEQUENCE() function, a new built-in function in Excel. ...
You can insert an image in Excel by simply dragging and dropping it anywhere in your worksheet. Its a floating image, that is, you can drag or move the image anywhere in your worksheet. However, with ...
Let us assume, I have multiple tables in my Excel worksheet. I want to email the tables as it is (with color, fonts etc.) as HTML table in the email body. I’ll show you how easily you can do this ...