No Thumbnail

Tekla Open API: Insert Single Rebar

This article explains how you can add a single rebar to a concrete part in a Tekla Structure model using the Tekla Open API in VB.Net. – Step 1: Add reference to the Tekla.Structures.Model and Tekla.Structures library located in the path “C:Program FilesTekla Structures20.0ntbinplugins” and manually open

No Thumbnail

Open Google Earth Using VBA for Access. Google Earth API

This article explains how you can use VBA for Access to open google earth. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the

No Thumbnail

Excel VBA, Remove Fill Pattern

Jump To: Remove Fill Pattern From Cell Remove Fill Pattern From Range Remove Fill Pattern From Column Remove Fill Pattern From Row Remove All Fill Pattern From Sheet – Remove Fill Pattern From Cell: The following line of code removes the fill pattern from cell

No Thumbnail

VB.Net Open Google Earth (Google Earth API)

This article explains how you can use VB.Net to open google earth. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the version might

Word Mail Merge Match Fields

I’ve previously explained about the Address Block and Greeting Line features of  Mail Merge in the articles below: Word Mailings Address Block (Mail Merge) Word Mailings Greeting Line (Mail Merge) Basically what they do is, they generate a block of text containing the recipient’s address and

No Thumbnail

Excel Hyperlinks To Cell or Range

In this article I will explain how you can create hyperlinks in Excel that will take the user to another location in the workbook. For example lets say we have the following data in sheet1: When the user selects each item, we want the user to

No Thumbnail

Access Startup Form

Previously in the article Open Form When Database is Opened, Access I’ve explained how you can use an “Autoexec” macro to open a certain form every time the access file is opened. In this article another method will be explained. – Step 1: Click on the File button: –

DLookUp, Access Expression Builder

This article will explain the DLookUp function used in the Access expression builder. – Syntax: =DLookup(expr, domain [, criteria] ) expr: The field whose value will be returned. String expression. domain: The set of records where the value will be retrieved from. String expression. criteria:

Excel VBA, Export Worksheet to Blank Access Table

In this article I will explain how you can export values from an excel worksheet to a new blank Access table. – Step 1: The first step would be to connect to an existing access database or create a new access database. In this example we

No Thumbnail

Excel VBA, Fill Pattern

Various different patterns can be applied to cells in Excel. These patterns can be applied manually using the Format Cell dialog: This article will explain how you can apply different patterns to cells using VBA for Excel. Jump To: Basics Example 1, Set Pattern Example