Macros & Excel VBA Archives - Page 23 of 50

Excel VBA: Save and Close Workbook (5 Suitable Examples)

Jun 16, 2024

For this tutorial, we have taken a dataset consisting of 3 columns: “Name”, “Born”, and “Latest Work”. This dataset represents 6 people’s birth year ...

Excel VBA: Save and Close Workbook (5 Suitable Examples)

How to a Save Workbook in a Specific Folder Using VBA in Excel (4 Methods)

May 10, 2024

The below dataset consists of 3 columns: Name, Car Model, and Car Maker. This dataset represents the car information of 6 employees car information ...

How to a Save Workbook in a Specific Folder Using VBA in Excel (4 Methods)

How to Save VBA Code in Excel (3 Suitable Methods)

Jul 6, 2024

Method 1 - Save a VBA Code with an Excel Workbook You can save the full workbook with macros. But you have to use another format to keep the macros. ...

How to Save VBA Code in Excel (3 Suitable Methods)

How to Save a Worksheet as a New File Using Excel VBA

May 1, 2024

Excel VBA: Save a Worksheet as a New File (Quick View) Sub Save_Worksheet_as_New_File() Sheet_Name = "Sheet1" New_File = "New_Sheet1" ...

How to Save a Worksheet as a New File Using Excel VBA

Excel Macro to Goal Seek for Multiple Cells (3 Methods)

May 9, 2024

Method 1 - Using Macro to Change Goal Seek for Multiple Cells Use ALT+F11 or go to the Developer tab and select Visual Basic to open ...

Excel Macro to Goal Seek for Multiple Cells (3 Methods)

Send Email from Excel VBA without Outlook: 4 Suitable Examples

May 19, 2024

Method 1 - Sending Single Email from Gmail Account Using Excel VBA Steps: Go to Developer >> Visual Basic The VBA window will ...

Send Email from Excel VBA without Outlook: 4 Suitable Examples

Lock a Cell after Data Entry Using Excel VBA with Message Box Notification Before Locking

Jun 27, 2024

In this article, we will use 2 methods to lock a cell after data entry using Excel VBA. To illustrate these methods we will use the dataset below. ...

Lock a Cell after Data Entry Using Excel VBA with Message Box Notification Before Locking

Macro to Send Email from Excel (5 Suitable Examples)

Jul 3, 2024

We'll use a simple dataset with a list of people, their emails, and the city they're from to send emails to them. Use Macro to Send Email ...

Macro to Send Email from Excel (5 Suitable Examples)

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

Jun 30, 2024

In this article, we’ll demonstrate a quick, effective method to generate reports in Excel using Macros. Quick View of the Macro Code Private ...

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

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

Jun 20, 2024

What Is a CSV File? A CSV file is a comma-separated values file, which saves data in an organized format. CSV files are compatible with many ...

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

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

Jul 26, 2024

We have a dataset of some students containing their names, class, and percentage in the examination. There are some blank cells in the Percentage ...

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

Excel VBA: How to Replace Text in a String – 5 Methods

Aug 2, 2024

This is the sample dataset. Method 1 - Using Excel VBA to Replace a Text Starting in the n-th Position of a Random String Step ...

Excel VBA: How to Replace Text in a String – 5 Methods

How to Send an Email to an Address in a Cell using an Excel Macro- 2 Methods

Aug 11, 2024

This is an overview: Sub Send_Email_with_Attachment() Dim MyOutlook As Object Set MyOutlook = CreateObject("Outlook.Application") Dim MyMail ...

How to Send an Email to an Address in a Cell using an Excel Macro- 2 Methods

Unprotect Excel Sheet Without Password Using VBA: 3 Simple Steps

Jul 5, 2024

Method 01 - Opening Visual Basic Editor Window We have a sheet VBA where we have some records of the products, and we have protected it with a ...

Unprotect Excel Sheet Without Password Using VBA: 3 Simple Steps

Excel VBA to Print As PDF and Save with Automatic File Name (9 Methods)

May 6, 2024

Method 1 - Print Workbook to PDF & Save File Name Automatically in Excel In this example we will print the whole workbook and save the ...