The information in this article applies to:
SYMPTOMSThe GeoFacts.vbp sample project that ships with Visual Basic 5.0 fails with the following run-time error when run on a machine that has Excel 97 for Windows installed: This error does not occur on a machine that has Excel 95 for Windows installed. CAUSEThe Type Mismatch error occurs on the following line of code:
The GetObject function, when passing a workbook file argument, returns a
Worksheet object when using Excel 95 but returns a Workbook object when
using Excel 97. The Type Mismatch error occurs because the shtWorld
variable is declared as Excel.Worksheet, which is not compatible with a
Workbook object.
RESOLUTIONTo make the project compatible with Excel 97 for Windows, you must change the following line of code (located in the General Declarations section of Module1):
to:
-or-
NOTE: Declaring the variable as Object allows the project to run with both
Excel 95 and Excel 97.
STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been fixed in Visual Basic 6.0. MORE INFORMATIONThe GeoFacts.vbp sample project was designed for Excel 95. However, you can write your automation code so that it is compatible with both Microsoft Excel 95 and Microsoft Excel 97. See the REFERENCES section below for more information. REFERENCESFor more information regarding how to make automation code compatible with multiple versions of Excel please see the following articles in the Microsoft Knowledge Base: Q143461 XL97: CreateObject and GetObject Work Differently Q178167 GeoFacts Sample Causes Automation Error on NT Additional query words: Excel
Keywords : kbAutomation kbVBp kbVBp500bug kbVBp600fix kbGrpVB kbExcel97 |
Last Reviewed: February 2, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |