Tag Archives: Delete

No Thumbnail

Word VBA, Delete Empty Rows From Tables

One of the things a lot of word users encounter while working in word, are empty rows in tables. In this article I will provide a code that will delete all empty rows from all tables in the document. – Delete Empty Rows From Single Table: In

No Thumbnail

Word VBA, Delete Equations

In order to delete an equation using VBA for word, you will have to know its index. Equations are referenced through the OMaths collection. In the example the below the first equation in the document is removed along with all its text: OMaths.Item(1).Range.Select Selection.Delete Before: After:

No Thumbnail

VBA, Word Table Insert/Remove Rows/Columns

In this article I will explain how you can add and delete rows and columns from tables in a word document using VBA. Every word document has a Tables collection The first step in working with a table in VBA for word is to determine the

Word, Delete Merge Sequence # Rule (Mail Merge)

The Merge Sequence # Field is not visible by default: In order to delete the Merge Sequence # Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the MERGESEQ Field: Step 3: Delete it:   See also:

No Thumbnail

VBA Delete File

In this article I will explain how you can delete files using VBA. – Basics: The code below will delete the file specified by the path associated to the variable strPath: Sub Example1() Dim ObjFso As Object Dim strPath As String ‘file path strPath = “D:StuffBusinessTempTempFile.xlsx” Set

No Thumbnail

Word VBA, Adding Caption to Images

In this article I will explain how you can add captions to images using VBA. As previously explained there are 2 types of images: Inline Floating The concept of adding caption to the two different types of images is pretty much the same. – Inline

No Thumbnail

Word VBA, Bookmarks

In this article I will explain the basics of working with bookmarks in VBA for word. – Creating Bookmarks: Bookmarks can be created by using the Add method of the Bookmarks collection: Bookmarks.Add (“bmName”) The input parameter to the Add method is a text string to name the bookmark.

No Thumbnail

Access Delete Tables

This article explains how to delete tables from an Access database. – Step 1: Right click on the tables tab and click on close: – Step 2: Right click the table on the left and click on Delete: See also: Access Create Table Access Tables

Delete Record, Access VBA Recordset

In this article I will explain how you can delete a record from an Access table using the Recordset object in 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