Macros & Excel VBA Archives - Page 19 of 50

Excel VBA: Check If Workbook Is Open and Close It (5 Examples)

Dec 11, 2023

If you want to check if a workbook is open and close it using VBA then you have come to the right place. Here, we will walk you through 5 easy and ...

Excel VBA: Check If Workbook Is Open and Close It (5 Examples)

[Fixed!] Method Open of Object Workbooks Failed (4 Solutions)

Nov 7, 2023

“Method open of object workbooks failed” occurs during run-time when code is executed. It is a common error that occurs during run-time. If you are ...

[Fixed!] Method Open of Object Workbooks Failed (4 Solutions)

VBA Code to Convert XML to Excel (Apply with Quick Steps)

Dec 21, 2023

XML files are used for data purposes. But when we need to use this data, we can not open an XML file directly using MS Excel. However, there are some ...

VBA Code to Convert XML to Excel (Apply with Quick Steps)

How to Use Macro to Save Excel File with New Name (5 Ways)

Dec 10, 2023

This tutorial will demonstrate how to use a macro to save an Excel file with a new name. If you have a particular Excel file that you need to use ...

How to Use Macro to Save Excel File with New Name (5 Ways)

How to ReDim Preserve 2D Array in Excel VBA (2 Easy Ways)

Dec 18, 2023

An array is a variable that keeps the same kinds of data. If there is only one row or one column of data, then it is known as a one-dimensional ...

How to ReDim Preserve 2D Array in Excel VBA (2 Easy Ways)

How to Add Sheet with Name in Excel VBA (6 Easy Ways)

Dec 5, 2023

This article provides the answers to your questions on how to add a sheet with name in Excel VBA. If you are looking for such unique kinds of tricks, ...

How to Add Sheet with Name in Excel VBA (6 Easy Ways)

Unable to Set the Visible Property of the Worksheet Class – 3 Solutions

May 1, 2024

Sometimes trying to change the visible property in Microsoft Excel results in the error message "unable to set the visible property of the ...

Unable to Set the Visible Property of the Worksheet Class – 3 Solutions

Excel VBA: Create a New Workbook and Name It (6 Examples)

Dec 5, 2023

Looking for ways to know how to create a new workbook and name it using VBA in Excel? Sometimes, we want to create a new workbook with a name in ...

Excel VBA: Create a New Workbook and Name It (6 Examples)

Excel VBA to Add Sheet If It Does Not Exist (with Quick Steps)

Dec 5, 2023

Excel VBA is a powerful and handy tool to perform tasks pretty quickly in a bulk amount. You can apply several conditions and derive different ...

Excel VBA to Add Sheet If It Does Not Exist (with Quick Steps)

How to Create New Sheet from Template Using Macro in Excel

Dec 5, 2023

If you want to create a new sheet from a template using macro in Excel, you have come to the right place. Here, we will walk you through 3 easy ...

How to Create New Sheet from Template Using Macro in Excel

How to Add Sheet with Name from Cell Using Excel VBA

Nov 5, 2023

We can save valuable time by using the Excel VBA Macro. Often, we need to add new sheets and name them from a cell manually, but we can do it ...

How to Add Sheet with Name from Cell Using Excel VBA

[Fixed!] Sub or Function Not Defined in Excel VBA

Nov 7, 2023

‘Sub or Function not defined’ is a compilation mistake in Excel VBA. When anything specified by name cannot be found, VBA shows this warning. Before ...

[Fixed!] Sub or Function Not Defined in Excel VBA

How to Generate XML File from Excel Using Macro (3 Methods)

May 3, 2024

The first dataset lists the names that will be applied to the new XML files. This sample dataset will be converted to an XML file. ...

How to Generate XML File from Excel Using Macro (3 Methods)

Automation of Bank Reconciliation with Excel Macros

Dec 19, 2023

Banking reconciliation statements summarize bank and business activity. Using financial records and bank accounts, they reconcile a company’s ...

Automation of Bank Reconciliation with Excel Macros

How to Insert Page Number Using VBA in Excel (3 Macros)

Dec 19, 2023

We can insert page numbers in Excel by applying commands, but if we use VBA, we can do it more smartly and quickly along with some customizations. ...