Microsoft KB Archive/185020

= XL98: Run-Time Errors Running Macro Created in Non-English Excel =

Article ID: 185020

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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.
 * 1) Double-click one of the module sheet.

A module sheet is activated.
 * 1) On the Edit menu, click Select All.
 * 2) On the Edit menu, click Copy.
 * 3) Switch to the Project Explorer (press COMMAND+R).
 * 4) In the Project Explorer window, click the new workbook that you created in step 1.
 * 5) On the Insert menu, click Module.
 * 6) 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.

Additional query words: XL98

Keywords: kbprb KB185020

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.