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

No Thumbnail

Word VBA, End of File

In this article I will explain how you can check if you’ve reached the end of a word document using VBA. In the articles below I’ve explained how to get the current page and line number the cursor is on: Word VBA, Get Current Line

No Thumbnail

Referencing Ranges In Excel Using VBA

In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,

No Thumbnail

VBA Word, Select Text

In this article I will explain how you can use VBA for word to select text. – Select Entire Document: Using the code snippet below you can select the entire word document: Selection.WholeStory Result: – Select The Current Line: Using the code below you can select the current line: Sub main() Selection.HomeKey

No Thumbnail

Word VBA Equations Linear/Professional Display

In this article I will explain how you can use VBA for Word to change the way equations are displayed in a word document. For more information about working with equations please see the link below: Word VBA, Equations – Equation Linear Display: Equations can be

No Thumbnail

Append Data to Table, Access VBA

In this article I will explain how you can append data to an Access table using VBA. The article uses the ADODB.Recordset object. In order to use this object you may need to add reference to ADODB object library. For more information on this topic please see the

No Thumbnail

Excel, Custom Formatting, Month Language

If you’ve worked with dates in Excel there may be times you want to display dates in a language other than english. For example lets say you want to display the following date in german: German equivalent: As previously explained in the article below you have 2 different

Mail Merge Next Record Rule (Mail Merge)

In this article I will explain the Next Record Field of Mail Merge. The Next Record Field can be used to display multiple records in one document. – What is it? Consider the letter below: The letter consists of 2 greeting lines which belong to 2 separate records. By