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

Word, Delete Next Record Rule (Mail Merge)

The Next Record Field is not visible by default: In order to delete the Next Record Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the NEXT Field: Step 3: Delete it:   See also: Word, Mail Merge

No Thumbnail

Word VBA, Open Document

In this article I will explain how you can open a word document using VBA. – Opening Word Document: If you are opening a word document from word you can use the code below: Sub main() Documents.Open (“D:TestFolderMain.docx”) End Sub Where “D:TestFolderMain.docx” is the path where the word

No Thumbnail

Excel VBA, Sheet Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Row: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples

No Thumbnail

Excel Custom Formatting, @ Character

If you’ve been reading about custom formatting in Excel you’ve probably stepped on the @ character. So what is it? For input values of the text type the @ character specifies where to put the the text. I will explain this using examples – Example

No Thumbnail

File and Folder Dialoges VBA

You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.