Macros & Excel VBA

How to Unprotect Excel Sheet with Password Using VBA (3 Quick Tricks)

While working with Microsoft Excel, sometimes we need to unprotect our protected dataset for the convenience of our work. Basically, we may need to ...

How to Create a Simple Database in Excel VBA

In this article, I’ll show you how you can create a simple database using VBA in Excel. Download Practice Workbook Download this practice ...

VBA Code for Subtotal in Excel (3 Ways)

In generic terms, subtotal refers to the total of one set of a larger group of sets. Excel is widely used to store crucial numeric information of ...

Excel VBA to Import CSV File without Opening (3 Suitable Examples)

In this article, we will demonstrate different examples of using Excel VBA code to import a CSV file without opening it. Sometimes, we get our ...

VBA to Split String into Multiple Columns in Excel (2 Ways)

Sometimes we have to deal with pretty long strings in our Excel dataset and that is not quite convenient to work with always. Implementing VBA macro ...

Excel VBA: Open Word Document and Paste (3 Suitable Examples)

This article illustrates how to open a new or existing word document from Excel and paste data into it using VBA with 3 different examples. We’ll use ...

How to Generate a Word Document from an Excel Macro

While working in Excel, we often need to generate a word document from Macro to copy our valuable data from the Excel worksheet to the word file. In ...

How to Transpose Rows to Columns Using Excel VBA (4 Ideal Examples)

For transposing rows to columns in Excel, there are many ways but we can do it smartly with lots of customization using VBA. From this article, we’ll ...

How to Import Text File to Excel Using VBA (3 Easy Ways)

This article illustrates how to import a text file to Excel using VBA code with 3 suitable examples. We’ll use Excel’s built-in Split, InStr, and ...

How to Apply Macro to Convert Multiple Excel Files to CSV Files

One of the common problems that most of us face in our daily lives while working with Macro in Excel is how to convert multiple Excel files to CSV ...

VBA to Hide Rows Based on Cell Value in Excel (14 Examples)

Sometimes we need to hide some specific rows based on various values from different cells in our large dataset in Excel for better readability. ...

Print to PDF Using Macro Button in Excel (5 Macro Variants)

Working with PDFs in Excel is common among users. PDF printing is one of the repetitive instances users find themselves in. Excel print to PDF Macro ...

Excel VBA: Import Comma Delimited Text File (2 Cases)

Excel offers some cool features to import txt, csv, etc. files in the worksheet. Suppose, we have a sample text file containing Text and commas as ...

Excel VBA to Read CSV File Line by Line (3 Ideal Examples)

Nowadays, the CSV (Comma Separated Values) file format is quite popular due to its simplicity. Readers can easily understand and analyze the data. ...

Excel VBA to Convert CSV File to XLSX (2 Easy Examples)

In this article, we will learn to convert a CSV file to an XLSX file with Excel VBA. We can perform this task manually. But with VBA, we can convert ...

ExcelDemy
Logo