Text – String Functions

Text & String Functions Explained with Examples

Create Microsoft Scripting Runtime Reference

Microsoft Scripting Runtime Reference

Create Microsoft Scripting Runtime Reference Create Microsoft Scripting Runtime Library Reference. Here are the instructions to add reference before running below VBA macro code. Table of Contents: Overview Step by step instructions to add Microsoft Scripting Runtime Library reference Create FSO Object VBA FSO Auto List Members Enable VBA FSO Auto List Members Step by …

Create Microsoft Scripting Runtime Reference Read More »

VBA Loop Through XLAM Files in a Folder

VBA Loop Through XLAM Files in a Folder

VBA Loop Through XLAM Files in a Folder VBA Loop Through xlam Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .xlam files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. Table of …

VBA Loop Through XLAM Files in a Folder Read More »

VBA List all XLSX Files in a Folder

VBA List all XLSX Files in a Folder VBA List all xlsx Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .xlsx files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. Table of …

VBA List all XLSX Files in a Folder Read More »

VBA Loop Through TXT Files in a Folder

VBA Loop Through TXT Files in a Folder

VBA Loop Through all TXT Files in a Folder VBA Loop Through all TXT Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .TXT files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. …

VBA Loop Through TXT Files in a Folder Read More »

VBA Loop Through all XML Files in a Folder

VBA Loop Through all XML Files

VBA Loop Through all XML Files in a Folder VBA Loop Through all XML Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .XML files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. …

VBA Loop Through all XML Files in a Folder Read More »

VBA Loop Through all CSV Files in a Folder

VBA Loop Through all CSV Files in a Folder

VBA Loop Through all CSV Files in a Folder VBA Loop Through all CSV Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .CSV files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. …

VBA Loop Through all CSV Files in a Folder Read More »

VBA Find all XLSM Files in a Folder

VBA Find all XLSM Files

VBA Find all XLSM Files in a Folder VBA Find all XLSM Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .XLSM files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. Table of …

VBA Find all XLSM Files in a Folder Read More »

VBA Loop Through PDF Files in a Folder

VBA Loop Through all PDF Files in a Folder in Excel

VBA Loop Through PDF Files in a Folder VBA Loop Through PDF Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .PDF files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. Table of …

VBA Loop Through PDF Files in a Folder Read More »

VBA Loop Through all XLS Files in a Folder

VBA Loop Through all xls Files in a folder

VBA Loop Through all XLS Files in a Folder VBA Loop Through all xls Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .xls files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. …

VBA Loop Through all XLS Files in a Folder Read More »

VBA Array Filter Function

VBA Array Filter function

VBA Array Filter Function The filter function returns an array, which contains subset of string based on specified criteria. Table of Contents: Overview of VBA Filter Function in Excel Syntax of VBA Filter Function in Excel Includes all filtered strings – case sensitive Extract all filtered strings – not a case sensitive Excludes or doesn’t …

VBA Array Filter Function Read More »

VBA Convert Column Letter to Number

VBA Convert Column Letter to Number in Excel

VBA Convert Column Letter to Number Convert Column Letter to Number in Excel VBA. Usually VBA programmers, refer column names or numbers. In general column header names represents like A,B, C,D,… . Lets assume we may want to know column ‘E’ represents which number. It represents number ‘5’. We can say it easily because we …

VBA Convert Column Letter to Number Read More »

VBA Convert Column Number to Letter in Excel

VBA Convert Column Number to Name in Excel

VBA Convert Column Number to Letter VBA Convert Column Number to Letter in Excel or Column Name. Most of the times when we are writing programs in Excel, we refer column names or numbers. In general column header names represents like A,B, C,D,… . Lets assume we may want to know 5th column represents which …

VBA Convert Column Number to Letter in Excel Read More »

VBA Multi-Dimensional Array in Excel

Multi - Dimensional Array

VBA Multi-Dimensional Array in Excel VBA Multi-Dimensional Array in Excel.The Multi-Dimensional Arrays uses more than two indexes(Subscripts). We can have up-to 60 dimensions in an array. Table of Contents: Overview of VBA N-Dimensional Array in Excel Syntax of VBA Multi-Dimensional Array in Excel Example for VBA N-Dimensional Array in Excel Instructions to use Macro Code …

VBA Multi-Dimensional Array in Excel Read More »

VBA Three-Dimensional Array in Excel

VBA Three-Dimensional Array in Excel VBA Three Dimensional Array in Excel. The 3Dimensional Array has three dimensions and uses three indexes(Subscriptss). The three subscripts(indexes) are separated with comma symbol. For example one index represents the rows, second one represnts the columns and third one represnts the charts. We refer Excel worksheet or cudbe for 3Dimensional …

VBA Three-Dimensional Array in Excel Read More »

VBA Two-Dimensional Array in Excel

Two - Dimensional Array

VBA Two-Dimensional Array in Excel VBA Two-Dimensional Array in Excel. Two Dimensional Array ahs two dimensions and uses 2 Indexes. The two indexes are separated with comma symbol. For example one index represents the rows and other represnts the columns. The 2Dimensional array also called as rectangular array. We refer Excel worksheet or table for …

VBA Two-Dimensional Array in Excel Read More »

VBA One-Dimensional Array in Excel

One - Dimensional Array

VBA One-Dimensional Array in Excel VBA One-Dimensional Array in Excel. The One(1)-Dimensional Array uses only one index(Subscript). The one-dimensional array consists of list of items of same data type. It consists of either single row or column data. We read values from an array or into an array using index value. The one dimensional array …

VBA One-Dimensional Array in Excel Read More »

VBA Array Erase Function in Excel

VBA Array Erase function

VBA Array Erase Function VBA Array Erase Function in Excel. The Erase function is used to reset(reinitialise) the size of an array. It depends on type of an array . That is either static or dynamic array. Table of Contents: Overview of VBA Erase Function in Excel Syntax of VBA Erase Function in Excel VBA …

VBA Array Erase Function in Excel Read More »

VBA Array Join Function in Excel

VBA Array Join function

VBA Array Join Function VBA Array Join Function in Excel. The Join function helps us to join sub strings in an array and returns a single string. It is an opposite of VBA Array Split function. We can also use ‘&’ operator to concatenate strings. It performs same like the join function. Table of Contents: …

VBA Array Join Function in Excel Read More »

VBA Array IsArray Function in Excel

VBA Array IsArray function

VBA Array IsArray Function in Excel VBA Array IsArray function checks whether the specified input variable is an array or not. It returns a boolean value. The specified input varaible ia an array then returns True, otherwise returns False. Let us examples in the following tutorial. Table of Contents: Overview of VBA IsArray Function in …

VBA Array IsArray Function in Excel Read More »

VBA Array UBound Function in Excel

VBA Array UBound function

VBA Array Upper Bound(UBound) Function Let us see about VBA arrays Upper Bound or UBound function in Excel VBA. The UBound function represents the Upper Bound value of an array. It returns the highest subscript(Index) value of specified array. It helps to determine the existing an array end size. Table of Contents: Overview of VBA …

VBA Array UBound Function in Excel Read More »