PRB: 16-Bit Microsoft Excel ISAM Requires Named Ranges
PSS ID Number: 145680
Article Last Modified on 1/9/2003
The information in this article applies to:
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
This article was previously published under Q145680
SYMPTOMS
The 16-bit Microsoft Excel ISAM (MSXL2016.DLL) included with Visual Basic
4.0 requires that all ranges to be accessed be previously named from within
Microsoft Excel. This is in contrast to the 32-bit Excel ISAM
(MSXL3032.DLL), which is able to accept an ad-hoc range as the name of a
table, for example "Sheet1$A1:E5".
RESOLUTION
Name all ranges to be accessed in Microsoft Excel before attempting use
from the 16-bit Microsoft Excel ISAM. This can be accomplished by starting
Microsoft Excel, loading the desired workbook, selecting the desired range,
clicking Insert Name Define on the Insert menu, and entering the name of
the range. The name you enter becomes the name of the data table attached
or opened using the Microsoft Excel ISAM. If this is not an option, one can
use OLE Automation to Microsoft Excel to manually retrieve the desired
data. Note that this method will require that Microsoft Excel exist on all
machines which execute the program. For more information on using OLE
Automation to Microsoft Excel (and other Office products) please see the
following article(s) in the Microsoft Knowledge Base:
122734 Article List for VB: OLE
STATUS
This behavior is by design.
REFERENCES
"Accessing Data in a Microsoft Excel Worksheet or Workbook," Visual Basic
4.0 online help.
Additional query words: 4.00 vb4win vb416
Keywords: kbIISAM kbprb KB145680
Technology: kbAudDeveloper kbVB16bitSearch kbVB400 kbVB400Search kbVBSearch