Macros & Excel VBA Archives

How to Use Macro to Send Email from Excel (5 Suitable Methods)

May 23, 2022 Macros & Excel VBA

In this article, we’ll show you 5 Macro to send email from Excel. To demonstrate our methods, we’ve selected a dataset with 3 columns: “Name”, ...

How to Automate Excel Reports Using Macros (3 Easy Ways)

May 24, 2022 Macros & Excel VBA

In this article, I’ll show you how you can automate your Excel reports in the offices using Macros. Automate Excel Reports Using Macros (Quick ...

How to Generate Reports Using Macros in Excel (with Easy Steps)

May 24, 2022 Macros & Excel VBA

While working with Microsoft Excel, sometimes we need to generate a report. Generating a report in Excel is an easy task. This is a time-saving task ...

Excel VBA to Read CSV File into Array (4 Ideal Examples)

May 23, 2022 Macros & Excel VBA

While working with the dataset, we occasionally receive data in CSV format. A CSV file is a text file with commas separating information. However, ...

Excel VBA to Replace Blank Cells with Text (3 Examples)

May 23, 2022 Macros & Excel VBA

We can detect blank cells and replace them with text using different methods in Excel. Excel VBA is one of the methods. In this section, we will show ...

Excel VBA: How to Replace Text in String (5 Effective Ways)

May 23, 2022 Macros & Excel VBA

If you are looking for ways to replace text in a string using Excel VBA, then you will find this article useful. Replacing a certain text part may ...

Macro to Send Email from Excel with Body (3 Useful Cases)

May 23, 2022 Macros & Excel VBA

While working in Excel, you might send an email from Excel keeping a simple text, copied cell range, or even a table from a working sheet. In this ...

Excel Macro: Send Email to an Address in Cell (2 Easy Ways)

May 23, 2022 Macros & Excel VBA

In this article, I’ll show you how we can develop a Macro to send an email to an address from a cell in a worksheet in Excel. Excel Macro to ...

Excel VBA: How to Unprotect Excel Sheet without Password

May 22, 2022 Macros & Excel VBA

If you are looking for ways to unprotect an Excel sheet without a password with the help of VBA, then you will find this article useful. Sometimes ...

Excel VBA to Print As PDF and Save with Automatic File Name

May 22, 2022 Macros & Excel VBA

There are benefits to exporting an Excel spreadsheet as a PDF document. By changing the file to PDF format, we will be able to print and share it ...

How to Send Email from Excel with Body Using a Macro (with Easy Steps)

May 22, 2022 Macros & Excel VBA

This article illustrates 11 easy steps to send an email from Excel with a body using a macro. We’ll be using the Microsoft Outlook under the hood by ...

How to Open All Excel Files in a Folder and Copy Data Using VBA

May 22, 2022 Macros & Excel VBA

In this article, I’ll show you how you can open all the Excel files from a folder and copy data from them using VBA. Open All Excel Files in a ...

Excel Macro to Send Email Automatically (3 Suitable Examples)

May 19, 2022 Macros & Excel VBA

This tutorial will illustrate how to use excel macro to send an email automatically. We can configure our mailing feature using VBA macros. So, using ...

Excel VBA: Protect and Hide Formulas

May 22, 2022 Macros & Excel VBA

In this article, I’ll show you how you can protect and hide formulas with Excel VBA on an Excel worksheet with password. Excel VBA: Protect ...

How to Open Word Document and Save As PDF or Docx with VBA Excel

May 18, 2022 Macros & Excel VBA

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. This article will show you how to open a word ...