Programming

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 ReferenceRead 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 NumberRead 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 ExcelRead More »

VBA Loop Through all Files in subfolders

VBA Loop Through all Files in subfolders

VBA Loop Through all Files in subfolders VBA Loop Through all Files in subfolders using File System Object(FSO) and built-in Dir() function. VBA for each file in subfolder macro helps us to loop through all files in subfolders. In this tutorial we loop through subfolders and list all available files in subfolders using FSO early-binding …

VBA Loop Through all Files in subfoldersRead 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 ExcelRead 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 ExcelRead 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 ExcelRead More »

VBA Split String into Array in Excel

VBA Split String into Array

VBA Split String into Array in Excel VBA Split String into Array in Excel is regular task in data analysis. In this tutorial we use Dim statement, VBA Split function, array and Delimiter. Dim statement is used to declare array and string type variable. Here not defining the array size. VBA Split function creates an …

VBA Split String into Array in ExcelRead More »

VBA to compile and collate Multiple excel workbooks and sheets data in one sheet in new excel file

VBA to compile and collate Multiple excel workbooks and sheets data in one sheet in new excel file Question: Hi… I’m looking for comment for below scenario. 1.  I have 3 excel file named ABC1, ABC2 and ABC3. 2.  I want to copy selected range of rows and column (it’s same for all the 3 …

VBA to compile and collate Multiple excel workbooks and sheets data in one sheet in new excel fileRead More »

VBA Cascading Dropdowns in UserForm

VBA Cascading Dropdowns in UserForm Question:I have 3 columns :region country product. I want to  have dependent dropdowns like countries population based on region selection and products population based on countries drop-down. Now here’s the most important part- This should be done using FORM CONTROL dropdowns and not combo boxes or data validation. Can …

VBA Cascading Dropdowns in UserFormRead More »

Current Thursday Date of This Week using VBA Functions

VBA Current Thursday

Current Thursday Date: Current Thursday Date using Excel VBA Functions Now, DateAdd,Format and WeekDay. We have different methods and ways to find Current Week Thursday date. You can find below two specified macros or procedures to find Current week Thursday date of this week using VBA functions. i.e Date, DateAdd, WeekDay and Format. We are …

Current Thursday Date of This Week using VBA FunctionsRead More »

Current Friday Date of This Week using VBA Functions

VBA Current Friday

Current Friday Date: Current Friday Date using Excel VBA Functions Now, DateAdd,Format and WeekDay. We have different methods and ways to find Current Week Friday date. You can find below two specified macros or procedures to find Current week Friday date of this week using VBA functions. i.e Date, DateAdd, WeekDay and Format. We are …

Current Friday Date of This Week using VBA FunctionsRead More »

Current Saturday Date of This Week using VBA Functions

VBA Current Saturday

Current Saturday Date: Current Saturday Date using Excel VBA Functions Now, DateAdd,Format and WeekDay. We have different methods and ways to find Current Week Saturday date. You can find below two specified macros or procedures to find Current week Saturday date of this week using VBA functions. i.e Date, DateAdd, WeekDay and Format. We are …

Current Saturday Date of This Week using VBA FunctionsRead More »