XL98: Run-Time Errors Running Macro Created in Non-English Excel (185020)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q185020

SYMPTOMS

When you run a Visual Basic for Applications macro in Microsoft Excel 98 Macintosh Edition, you receive run-time errors.

CAUSE

This problem occurs if the Visual Basic for Applications macros were originally created in a non-English version of Excel.

WORKAROUND

To work around this problem, copy the code into a new workbook. To do this, follow these steps:

  1. Click the New button on the Standard toolbar to create a new workbook.
  2. Start the Visual Basic Editor (press OPTION+F11).
  3. Click Project Explorer on the View menu.
  4. In the Project Explorer, click the non-English workbook.
  5. Click the triangle next to Modules.

    A list of module sheets in the non-English file is displayed.
  6. Double-click one of the module sheet.

    A module sheet is activated.
  7. On the Edit menu, click Select All.
  8. On the Edit menu, click Copy.
  9. Switch to the Project Explorer (press COMMAND+R).
  10. In the Project Explorer window, click the new workbook that you created in step 1.
  11. On the Insert menu, click Module.
  12. On the Edit menu, click Paste.

    Repeat steps 6 through 12 for each module sheet in the workbook.
After you copy all of the Visual Basic code into a new workbook, the code is run with fewer errors. How well the code is run from another workbook depends on the assumptions that are made in the code.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb KB185020
©2002 Microsoft Corporation. All rights reserved.