Microsoft KB Archive/145680

= 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.

