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

No Thumbnail

Excel VBA Open File Dialog

There may be times when you need to ask the user to select a file to open. This can be done using the open file dialog. Keep in mind that the open file dialogs doesn’t actually open anything. It returns the path of the file

No Thumbnail

VBA Editor, Indent and Outdent Blocks of Code

In this article I will explain how you can indent and Outdent blocks of code. – Step 1, Select the Text to Indent: The first step would be to select the block of text you would like to indent: – Step 2, Press TAB: By

No Thumbnail

Excel INDEX MATCH Functions

You might have seen a lot of places talking about the INDEX and MATCH functions. The purpose of using the INDEX and MATCH functions together is to create a functionality similar to VLOOKUP. The problem with the VLOOKUP function is that it can only search

No Thumbnail

Word VBA, Read All Lines

In this article I will explain how you can use VBA to read every line in a word document and store the values in a string array/collection. – Method 1: In this method the VBA code will select the entire document. After selecting the entire document the

No Thumbnail

Excel VBA Range Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient colors. I’m assuming readers are familiar with the concepts explained in that article before reading this article. Jump To: Gradient Color, Range Modify Existing Gradients Color for Range – Gradient Color, Range:

No Thumbnail

Tekla Open API: Get Part Bounds

This article explains how you can get the min max bounds of a part object in a tekla model. Note part bounds will not be very useful when the part is not aligned in one of the 3 main directions. Step 1: Add reference to