Mail Merge Next Record Rule (Mail Merge)

In this article I will explain the Next Record Field of Mail Merge. The Next Record Field can be used to display multiple records in one document. – What is it? Consider the letter below: The letter consists of 2 greeting lines which belong to 2 separate records. By

No Thumbnail

Excel Functions and Formulas, IF()

In this article I will explain the IF() function. The IF() function receives 3 input parameters. The first input parameter is a logical test. The logical test will either equate to True or False. If the logical test equates to TRUE then the second parameter

No Thumbnail

Tekla Open API: Grids

This article explains how you can create/modify/delete grids in the model using the Tekla Open API in VB.Net. Step 1: Add reference to the Tekla.Structures.Model library located in the path “C:Program FilesTekla Structures20.0ntbinplugins” and manually open the tekla model. This has been covered in the article

No Thumbnail

Word VBA, Modify Table Data

In this article I will explain how you can use VBA to modify a table‘s data in word. If there are multiple tables in a word document the first thing to do is to determine which table you are going to modify. Basically tables are indexed starting

No Thumbnail

Excel VBA, Get Color Code

This article provides a sample for getting the desired color code. The user selects a fill color for the cell A1. After pressing the Get Code button the color code used will be printed in cell B1. It can be seen from the figures below that

No Thumbnail

Excel, Dates

When working in Excel there are going to be times where you need to specify a date value. There are different methods for specifying a date in Excel. This article briefly explains them and provides links to more detailed explanations. Before explaining the different methods

VBA, Create New Access Database From Excel

In this article I will explain how you can create a new (blank) access database from Excel. There are 2 methods for getting this done: Late Binding Early Binding In early binding we add a reference to the Access Object Library. The benefit of using early binding

No Thumbnail

Excel VBA, RGB

As previously mentioned in the article Excel VBA, Color Code when working with colors in Excel you must know their color code. Though sometimes you may want set the color by using the RGB color model. This can be achieved using the RGB() function. For more information

No Thumbnail

Excel, Custom Formats

In this article I will briefly explain the different concepts of custom formatting, and provide links to more detailed explanation of each. You can download the file related to this article from the link below Custom Formats.xlsx – Custom Date Formatting: There are endless ways  to display a