XL2000: "Catastrophic Failure" Error Running Samples.xls Macro

When you run the Microsoft Visual Basic for Applications sample macro, RetrieveISAMdata() in the Sample.xls workbook that ships with Microsoft Excel and Microsoft Office, the following error message appears: If you click Debug, the macro stops on the statement for the object:

This problem occurs when you run the RetrieveISAMdata() sample under the following conditions:

• You run Microsoft Excel on Windows Terminal Server.
  
  -and-
• You are using Microsoft Data Access Components (MDAC) version 2.1, which ships with Office 2000.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

When you install either Microsoft Excel or Microsoft Office, the Setup program installs the sample workbook to the following folder: NOTE: This location may be different depending on where you installed the Office program.

If you are running Microsoft Excel on Microsoft Windows Terminal Server, and you open the Samples.xls workbook, the error message appears when you click the ADO-ActiveX Data Objects worksheet, click Goto Retrieve ISAM Data Example Sample Code and then run the RetrieveISAMdata() sample macro.