ACC2: Reference to Cell Object Incorrect (116500)
The information in this article applies to:
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
| Modification Type: | Major | Last Reviewed: | 7/8/2002 |
|---|
| Keywords: | kbusage KB116500 |
|---|
|