Category Archives: Uncategorized

The Excel VBA Application.FileDialog Object

Have you ever wished you could develop a simple way for users to select files to open from within Excel? Perhaps you want to impose a level of control over which file path users select the file(s) from. This can be done by using the

No Thumbnail

Tekla Open API: Start/End Point Offsets

Understanding the start and end points of a part object is essential when working with parts. Start and end points are displayed using a square at both ends of the part: By modifying the start and end point offsets you will be able to change their relative position with

No Thumbnail

Word VBA, Delete Empty Rows From Tables

One of the things a lot of word users encounter while working in word, are empty rows in tables. In this article I will provide a code that will delete all empty rows from all tables in the document. – Delete Empty Rows From Single Table: In

No Thumbnail

Tekla Structures: Hide/Show Specific Objects in Model

Models made in Tekla can get very crowded with objects. Working in such a model can get very difficult without hiding some of the objects. This can be done by applying filters. Consider the reinforced concrete model below: Everything is visible in this model: Foundation Foundation

No Thumbnail

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

No Thumbnail

Excel VBA Drop Down Lists Using Data Validation

In this article I will explain how you can create drop down lists using data validation.   Jump To: Creating Data Validation (Manually) Creating Data Validation (Using VBA) Selection Change Modifying, Adding, Inserting and Removing Items (Usin VBA)   You can download the file and code related

No Thumbnail

Tekla Open API: Get/Set User Defined Attributes

This article explains how you can get/set user defined attributes using the tekla open api.   Step 1, Add Libraries: 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 Using Bookmarks to Move the Cursor

Bookmarks are a great way to specify important locations on the word document. Using VBA you can move the cursor to those bookmarks. – Creating Bookmarks Manually: For example assume you have the following data in a word document: We want to be able to modify