There are many ways you can run or execute a macro like, pressing the F5 key in VBA or simply clicking the run button. Or, you can insert a button (an ActiveX Control) on your Excel worksheet, click ...
In Excel, there is an in-built feature called the Subtotal (under the “Data” tab) which when used can automatically insert subtotals and grand total for a selected range of data. However, if you are ...
In my previous article on Excel automation using VBA, I have explained how to fill a web form and save the data, from Excel using VBA. The data that I have used in that example were hardcoded ...
Web scraping is a process where an application extracts data or content from a web page. You can do this from an Excel worksheet using VBA. I have shared an article here before where I have explained ...
While working on worksheets using a macro, you may sometimes need to know if a particular worksheet exists in a workbook or not. Especially, when the worksheets have random names. You either ...
You can insert a variety of objects like Excel workbook, PDF or Word document, images etc., in your email message using Outlook (any version). You can automate this process. I’ll show you how you can ...
Let us assume, I have two ranges of values in my Excel worksheet. Each range has two columns each (region and sales). Now, both the ranges have some common regions. How do you find the matching record ...
Let us assume, you receive sales data (or any data) from different regions or zones in multiple Excel files, via email or any other source. Now, you want to merge all the Excel files into one single ...
Its very common for Excel users to send emails to a list of contacts. Here in this post, I’ll show you how easily you can send emails to multiple recipients from your Excel workbook with the click ...
How to write data to a text file or in a .txt file from Excel using a Macro? I have shared an example here that explains it. ...