PRB: 16-Bit Microsoft Excel ISAM Requires Named Ranges

• Microsoft Visual Basic Professional and Enterprise Editions, 16-bit only, for Windows, version 4.0

SUMMARY

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

STATUS

This behavior is by design.

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:

Q122734 Article List for VB: OLE

REFERENCES

"Accessing Data in a Microsoft Excel Worksheet or Workbook," Visual Basic 4.0 online help.

Additional query words: 4.00 vb4win vb416

Keywords : kbDatabase kbIISAM
Version : WINDOWS:4.0
Platform : WINDOWS
Issue type :