Loops in VBA Loops are an essential part of any programming language because they help with the repeated running of any code snippet. Just like any other language, VBA offers the following loops to enable efficient programming: Do until Do while For Foreach In this
Used Area of an Excel Sheet There are many situations when we need to perform an action on all rows and columns with data in an Excel sheet. In order to do that, you need to know which row/column of data is the last. In
In this article I’m going to first show you how to create and run MS Access queries manually, then I’ll build on that by explaining how to automate the execution of these queries via Docmd.OpenQuery. Let’s get started! Microsoft Access is a database management tool
Defining a Range In Microsoft Excel, a “range” of cells is a continuous group of cells across rows and columns. Here’s some valid examples of ranges with references to the cells: Any single cell like H54, C3. A part of any row Eg: D4:G4, H10:N10.
Integer Datatype In Microsoft VBA, variant is a common datatype. It can be used to store strings or integers or even dates. Integer is a specific datatype which can be used to store numbers of a specific length. The bigger version of an integer is
All programming languages support the “if” type of conditional statement. An if block is executed during runtime only if the condition is met. i.e., the result of a condition is equal to the Boolean value “true.” Syntax If ( <conditional expression> ) ‘block of statements
Microsoft Access is a Database Management System which helps to store and manage data, reporting using forms/queries/various other wizards. As discussed in older posts and articles, queries can be built in Microsoft Access using design view/SQL view/any available wizard. In another post I explain the
Errors Happen We may come across several functions in programming languages. In VBA, we are prone to encounter errors like: Syntax errors Compile time errors Runtime errors These are errors in code which can be handled using error handling methods. For example, you can see
What is a Regular Expression? How is the Like Operator Related? In any programming language, there is a way to compare strings against some patterns. Several characters are used to create these patterns. These patterns are called regular expressions. Like in structured query language, VBA
Introduction to Cells In Microsoft Excel, a cell is nothing but an intersection of a column and a row. This cell is referenced by its row number and column letter. A cell can hold a formula/data directly. It can be formatted with font styles and