Category Archives: VBA for Word

All About Dim Statements in VBA

A variable is a named storage location in which you can store information while your macro/program is running.  Each variable has a unique name where the name can identify what type of variable it is by using standard naming conventions.  A variable can contain different

highlighted text to remove hyperlinks in word

How to Remove all Hyperlinks in a Word Document

What is a Hyperlink? A hyperlink is a word, phrase, or image that you can click on to jump to a new document or a new section within the current document. Text hyperlinks are often blue and underlined, but not necessarily. When you move the

convert table dialog box

How to Convert a Word or Excel Table to Text

The Table object in Excel and Word is underutilized by most users and developers of Excel and Word, in my not-so-humble opinion. For example, an Excel Table object with formulas calculates faster and takes less storage space than does the comparable normal range. As useful

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

No Thumbnail

Word VBA OverFlow Error When Multiplying/Adding Integers

It might have occurred to you when working with integers in VBA for Word that you get  the following error: This error generally occurs when  you are doing arithmetic operations on integer values that result in: Values larger than 32767 Values smaller than -32768 This is because integers only

No Thumbnail

Word VBA, Assign Shortcut Key to Macro

This article explains how you can assign a shortcut key or key combination to a macro. – Step 1: Press the “File” button on the top left of the word application, then click on options:   Note: In word 2007, there will be an “Office