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

No Thumbnail

VBA Set Camera, Google Earth API

This article explains how you can use VBA for Excel to automate Google Earth and set the camera to the location you want. It will be assumed there is KML file located in the path “D:StuffBusinessTempLocation.KML”. The KML file contains the required data for setting the camera

No Thumbnail

Word VBA, Crop Images

In this article I will explain how you can use VBA for word to crop images. The first step is to determine the type of image. There are 2 types of images: Inline Floating I’ve previously explained about the 2 image types in the article