Category Archives: Uncategorized

Excel VBA: Display File Name as Hyperlink

In this article we will show you how to display file name as a hyperlink to a file in Excel. We first introduced this concept in this article but will expand upon it here. For this we will use the Hyperlinks.Add Method. Let’s have a

Access Word Objects through Excel VBA

In this article, we will see how to access the various word objects using VBA in Excel and insert data from Excel to Word. This has many practical applications such as when you have to fill out a form multiple times with data from Excel or

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