Knowledge Base

ACC2: Reference to Cell Object Incorrect

Article ID: 116500

Article Last Modified on 7/8/2002

Microsoft Access 2.0 Standard Edition

This article was previously published under Q116500

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

On page 292 of the Microsoft Access version 2.0 "Building Applications" manual, "Cell" is referred to as a member of a Microsoft Excel OLE Automation object's list of objects. This reference is incorrect.

The following example is provided in the manual:

   ExcelObj.Cell(1,1).Font.Bold = True

RESOLUTION

The correct reference is "Cells," not "Cell."

The example in the manual should read:

   ExcelObj.Cells(1,1).Font.Bold = True

REFERENCES

Microsoft Access "Building Applications," version 2.0, Chapter 13, "Communicating With Other Applications," page 292

Keywords: kbusage KB116500