Automation Made Easy & Productive!
VBA Functions and Examples
VBA Create Folder in Excel. We use MkDir VBA function to create a folder. We creates a folder in a specific directory or current directory. Once we create folder, we store file or files in it. If folder already exists then it throws an error message. In this tutorial we explained examples and step by …
VBA Convert Integer To String With Leading Zeros. when dealing with large data bases we commonly see numbers without leading zeros. But when we add in Excel sheet it doesn’t allow leading zeros. So we are converting to string by adding single quote. After that we can add zeros. It doesn’t show single quote in …
VBA Convert Integer To String With Leading Zeros Read More »
VBA Convert Number Stored As Text To Number. Here the input value is number stored as number but in string format, we are converting this value as number. In the following article let us see an example. And also see the step by step instructions to run VBA code in the visual basic editor(VBE) window. …
VBA Convert Number To String, we use CStr data type conversion VBA function. The number can be integer, or any numeric value. In the following article let us see an example. And also see the step by step instructions to run VBA code in the visual basic editor(VBE) window. You can find link at the …
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. Table of Contents: Objective Example to find all .xls …
VBA Array Filter Function in Excel. The filter function returns an array, which contains subset of string based on specified criteria. Table of Contents: Objective 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 contain filtered string – …
VBA Loop Through all Files in subfolders using File System Object(FSO) and built-in Dir() function. VBA for each file in sub-folder macro helps us to loop through all files in sub-folders. In this tutorial we loop through sub-folders and list all available files in sub-folders using FSO early-binding and late-binding method and Dir() function. There …
VBA Currency Data Type in Excel explained with syntax and examples. We use the Currency VBA data type to store numbers in integer format and these numbers scaled by 10,000. The default value is 0. The Currency VBA data type contains range of values between -922,337,203,685,477.5808 to 922,337,203,685,477.5807. The data type Currency can be used …
VBA Object Data Type in Excel explain with syntax and examples. An object consists of reference to an object. It occupies 4 bytes (32 bits) in memory. We use Set statement for a convenient way to refer an object. Table of Contents: Objective Data Type Object Syntax in Excel VBA Example on the Object Data …
VBA Variant Data Type in Excel explained with syntax and examples.Variant Data Type in Excel VBA explained with syntax and examples. It is a special and universal data type to use for any kind of data except fixed length string. It is more flexible, but occupies more space in memory. Type declaration character is not …
VBA String Data Type in Excel explained with syntax and examples.String Data Type in Excel VBA explained with syntax and examples. Where string is nothing but sequence of characters. We use VBA data type string to store text. Text includes not only characters but also numbers, spaces and special characters. The string contains double-quotation-mark literal. …
VBA Double Data Type in Excel explained with syntax and examples.Double Data Type in Excel VBA explained with syntax and examples. We use VBA data type Double to store numbers which represents Double-precision floating-point variables. The default value is 0 and store decimal values. The VBA data type Double contains range of values -1.79769313486231E308 to …
Single Data Type in Excel VBA explained with syntax and examples. We use VBA data type single to store numbers which represents single-precision floating-point variables. The default value is 0 and store decimal values. The VBA data type single contains range of values -3.402823E38 to -1.401298E-45 for negative values, and 1.401298E-45 to 3.402823E38 for positive …
Date Data Type in Excel VBA explained with syntax and examples. The Date VBA date type stores floating point numbers that represents date and time. We can store date, time or date and time. It has date range values from Jan 1, 0100 to December 31, 9999 and time values from 0:00:00 to 23:59:59. Date …
Decimal Data Type in Excel VBA explained with syntax and examples.Decimal VBA Data Type in Excel VBA explained with syntax and examples. We use the Decimal VBA data type to store integer numbers scaled by a variable power of 10. The default value is 0. The Decimal VBA data type contains range of values +/-79,228,162,514,264,337,593,543,950,335 …
Long Data Type in Excel VBA explained with syntax and examples. We use the long VBA data type to store whole integer numbers. It is an alternative to integer. It occupies more range than integers. The default value is 0. The long VBA data type contains range of values between -2, 147, 483, 647 to …
Boolean Data Type in Excel VBA explained with syntax and examples. We use the Boolean VBA data type to store logical data. The Boolean VBA data type contains only two states of values either TRUE or FALSE. In other words we can also refer as 1 for True and 0 for False. The default value …
VBA Integer Data Type in Excel explained with syntax and examples. We use the integer VBA data type to store only integer whole numbers. The default value is 0. The integer VBA data type contains range of values between -32,768 to 32,767. Integers cannot have decimal places. The integer number can be positive number, negative …
VBA Byte Data Type in Excel explained with syntax and examples. It contains binary data and holds a value from 0 through 255. Byte type is categorized as a numeric data type. The default value of byte is 0. It is used to save space in memory. It is smaller than integer data type. We …
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 Syntax of VBA Multi-Dimensional Array in Excel Example for VBA N-Dimensional Array in Excel Instructions to Run VBA Macro Code Other Useful Resources Syntax of the Multi-Dimensional Array Function Here …