devxlogo

Visual FoxPro 6 and Microsoft Word Tables

Visual FoxPro 6 and Microsoft Word Tables

Question:
How can I make a table in a Microsoft Word document through OLE Automation from VFP? I investigated with the Visual Basic editor and I can’t find how to do it. Could you give me more information?

Answer:
You add a table to a Word document by calling the Add() method of the Tables collection of the currently active document:

Function Add(Range As Range, NumRows As Long, NumColumns As Long) As Table

The Add method takes three parameters. The first parameter is a range where the table should be placed. The second parameter is the number of rows in the table. The third parameter is the number of columns in the table.

The Add method returns an object reference to the table so that you can manipulate the table. To insert a table at the current cursor position, you can pass the Range property of the Selection property.

Here is a code sample that opens Word, makes it visible, creates a blank document, adds a table with three rows and two columns, fills in the cells of the table, and then pauses to allow you to see what the document looks like:

loWord = CREATEOBJECT("word.application")loWord.visible = .T.loWord.Documents.Add()loWord.Selection.TypeText("What follows is a 3x2 table.")loTable = loWord.ActiveDocument.Tables.Add(loWord.Selection.Range,3,2)loTable.Cell(1,1).Range.Text = "R1C1"loTable.Cell(1,2).Range.Text = "R1C2"loTable.Cell(2,1).Range.Text = "R2C1"loTable.Cell(2,2).Range.Text = "R2C2"loTable.Cell(3,1).Range.Text = "R3C1"loTable.Cell(3,2).Range.Text = "R3C2"MESSAGEBOX("Pause so that you can see what was done")loWord.Quit()

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist